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.
N3125WRowe Benjamin Stratton · Nome, AKN3125YOberdoerster Timothy L · Concord Township, OHN3125ZFabris Thomas H · Reva, SDN31261Lee Stan · Sarasota, FLN31262Sauer Roger A · Glenburn, NDN31263Handerson Ronald J · Sitka, AKN31266Registration Pending · Wasilla, AKRegistration pending, pending cancellationN31268Brown Gregory J · Cordova, TNN3126CWest Leland Dan · Elverta, CAN3126DMyers Martin John Trustee · Juneau, AKN3126EN3126e LLC · Columbus, OHN3126PJmc Duryea Investments LLC · Ocala, FLN3126TNicholson Homer L · Ponca City, OKN3126WHawaii Pacific Aviation Inc · Kailua Kona, HIN3126YOutdoor Freedom Inc · Camdenton, MON31272Nelson Debra M · Astoria, ORN31273Haselmo Zak-Newton · Park River, NDN3127CChaar LLC · Lock Haven, PAN3127DE & S Group LLC DBA · Columbia, CAN3127EAllison John W Jr · Brighton, CON3127FN3127f Aviation LLC · Charlotte, NCN3127LContainer Stop Inc · Paso Robles, CAN3127PThorn Blake A · Coupeville, WAN3127WWalkcon Holdings LLC · Amarillo, TXN3127ZLott William F Jr Trustee · Oklahoma City, OKN31280Kaster Kenny C · Prineville, ORN31283Somes Jason · Santa Rosa Valley, CAN31284Allen Earl R · Cottonwood, CAN31285Ramsey Blake P · Wasilla, AKN3128DCopsey Harvey J · Tucson, AZN3128FSwartzendruber Rodney S · Bay Port, MIN3128QK Bell Enterprises Inc · Columbia Falls, MTN3128RHuelsmann Gayle M · Albuquerque, NMN3128WSterling Anthony K · Wilson, NCN3128XWeiss Elliot · Fresno, TXN3128ZGrady Robert DBA · Lansing, ILN31291N31291 Aviation LLC · Omro, WIN31292Beranek John W · Prairieburg, IAN31293Scroggins Darrel T · Springfield, MON31294Molyneux Gawen G · Yucaipa, CAN31299Brion William F · Chugiak, AKN3129DHawgs Landing LLC · Warrensburg, MON3129PJudie Bear Air LLC · Bend, ORN3129QUrbanowski Edward F · Paxton, MAN3129TMcdaniel Timothy A · Hutchinson, MNN3129UJones Robert M · Brooksville, FLN3129ZCaldwell Caleb Z · Anchorage, AKN312ADAltier Daniel T · Bloomfield Twp, MIN312AVAshley Dallas · Cardiff By The Sea, CAN312BDOverton John W Jr · Minnetonka, MN
Back to AD 2007-04-19 R1