AD 2007-04-19 R1
Registered aircraft · 108,434
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
ORDER BY 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 n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') ORDER BY 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.
N427KMAviation Advantage LLC · Phoenix, AZN427KRDean Michael D · Montrose, CAN427KSJagged Ridge Imaging LLC · Bainbridge Island, WAN427LLForrest Jeffrey H · Bloomfield Hills, MIN427PWLangford Stephen C · York, SCN427RAHilty Benjamin D · South Boston, VAN427RDHeuerman Jordan Dale · Casey, ILN427RMWingsleasing LLC · Wichita, KSN427RSMadden James C · Salt Lake City, UTN427SBN16rn LLC · Lakewood, CON427SCJones Jeffrey A · Brooksville, FLN427SDBanning Keith K · Helena, MTN427SFN427sf LLC · Lakeview, NCN427TCag Farms Inc · Angier, NCN427WBColeman Steven R · Fernandina Beach, FLN427WYMayes Neil M · Lovell, WYN42800Asbury William J · Fresno, CAN42801Aas LLC · Ovid, MIN42804N42804 LLC · Brush, CON4280FRt Flyers LLC · Shakopee, MNN4280JWebberley Jason D · Kelso, WAN4280QHines Thomas J · Amsterdam, NYN4280SYoung Daniel R · Germantown, TNN4280ZKamlowsky Scott A · Anchorage, AKN42811Harris Patrick · Lincoln, CAN42812Skylink Aviation Inc · Florissant, MON42818Cleveland Jeffrey Allen Trustee · Indian Trail, NCN4281JLewis Mark · Ozark, ALN4281QMcdonald Air Services LLC · Saint Johns, MIN4281TTheodorakis Alkeviades S · Fort Pierce, FLN42820Cordobesa Aviation LLC · Belgrade, MTN42823Acs Products Co · Lake Havasu City, AZN42826Aero Elite Inc · Wilmington, DEN4282JDill Tharold J Jr · Boron, CAN4282PAero Tramp Holdings LLC · Dallas, TXN4282QShirley Walter Allen · Bullhead City, AZN4282SGoerzen John P · Goessel, KSN4282THudson John P III · Grapeland, TXN42831Shuff James S II · Victor, WVN4283JBennett Tim M · Cambridge, OHN4283SHayes Timothy · Gray, MEN4283TDziak Chester · Jackson, MIN4283ZHuseby Kelly E · Hulett, WYN4284Clements Eric C · Sheridan, WYN42849Moonrise Soaring Inc · Wilmington, DEN4284KHornblower Paul S · Chilmark, MAN4284PEmpire Aviators LLC · Long Island City, NYN4284TOsborne Thomas A · Bloomington, INN4284ZBolin Matthew R · Everett, WAN42851Emmons Steven · Russellville, AR
Back to AD 2007-04-19 R1