Ff22 LLC
Registered aircraft · 49
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'FF22 LLC' OR list_contains(g.other_registrant_names, 'FF22 LLC') ORDER BY g.n_number"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'FF22 LLC' OR list_contains(g.other_registrant_names, 'FF22 LLC') ORDER BY g.n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N129KTextron 172S · S/N 172S12825N209KTextron 172S · S/N 172S12826N240AAPiper PA-28-181 · S/N 2881731N242AAPiper PA-28-181 · S/N 2881732N243AAPiper PA-28-181 · S/N 2881733N244AAPiper PA-28-181 · S/N 2881734N245AAPiper PA-28-181 · S/N 2881758N249KTextron 172S · S/N 172S12830N264AAPiper PA-28-181 · S/N 2881759N266AAPiper PA-28-181 · S/N 2881760N383PTPiper PA-28-181 · S/N 2881603N460SCPiper PA-44-180 · S/N 4496551N46FFTextron 172S · S/N 172S12874N604FFPiper PA-28-181 · S/N 2881604N605FFPiper PA-28-181 · S/N 2881605N609SCPiper PA-28-181 · S/N 2881599N610SCPiper PA-28-181 · S/N 2881600N611SCPiper PA-28-181 · S/N 2881601N670LHPiper PA-28-181 · S/N 2881680N671LHPiper PA-28-181 · S/N 2881681N672LHPiper PA-28-181 · S/N 2881682N673LHPiper PA-28-181 · S/N 2881683N674LHPiper PA-28-181 · S/N 2881684N675LHPiper PA-28-181 · S/N 2881685N696LHPiper PA-28-181 · S/N 2881629N697LHPiper PA-28-181 · S/N 2881686N699LHPiper PA-28-181 · S/N 2881687N703PTPiper PA-28-181 · S/N 2881602N71FFTextron 172S · S/N 172S12935N72FFTextron 172S · S/N 172S12936N74FFTextron 172S · S/N 172S12937N75FFTextron 172S · S/N 172S12938N76FFTextron 172S · S/N 172S12939N79FFTextron 172S · S/N 172S12940N813SCPiper PA-28-181 · S/N 2881714N830SCPiper PA-28-181 · S/N 2881715N837SCPiper PA-28-181 · S/N 2881716N843SCPiper PA-28-181 · S/N 2881717N857SCPiper PA-28-181 · S/N 2881741N859SCPiper PA-28-181 · S/N 2881742N85FFTextron 172S · S/N 172S12949N860SCPiper PA-28-181 · S/N 2881743N874PAPiper PA-28-181 · S/N 2881339N875SCPiper PA-28-181 · S/N 2881744N876SCPiper PA-28-181 · S/N 2881745N87FFTextron 172S · S/N 172S12950N91FFTextron 172S · S/N 172S12951N9283ATextron 172S · S/N 172S12788N928ZATextron 172S · S/N 172S12786
Back to Ff22 LLC