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.
N2YPCollum Aviation LLC · Milton, FLN2YROverland Missions Inc · Cocoa, FLN2YYRd Enterprises LLC · Blacksburg, SCN2ZTwo Zulu LLC · Mclean, VAN2ZDMelin Lynn Glenn · Scottsdale, AZN2ZFSplit S LLC · Bayfield, CON2ZHClt Thompson Holdings LLC · Charlotte, NCN2ZKOlsen Christopher B · Albuquerque, NMN2ZVVanlaak James E · Honedale, PAN2ZWThordarson Gudsteinn Thor · La Porte, INN30002Drean Gary T · Rancho Santa Fe, CAN30005Hein Tanner T · Clayton, NCN30007Snow Carol A · Rattan, OKN30009Mock Joseph R · Huntsville, TXN3000DHungy Air LLC · Bettendorf, IAN3000QFlying H Enterprises · Santa Fe, NMN3000YChesebro Ben D · Tucson, AZN3000ZRegistered aircraftN30012Wfc Aviation Inc · Johnstown, PAN30013Patton Mark E · Dryden, NYN30014Tri-State Aviators LLC · Ironton, OHN30015N30015 LLC · Saunderstown, RIN30017Landon Kasiri · Lancaster, CAN3001CHoyt Robert H · Canby, ORN3001KHauck Drew Steven · Buffalo, MNN3001LSimmons Mark Q · Mclean, TXN3001PN3001p LLC · Aurora, OHN3001TSluka Christopher J · San Diego, CAN3001WLexington Flying Club Inc · Lexington, KYN3001XTerrebonne Aviation Inc · Houma, LAN30020Frieders Farm Corp · Waterman, ILN30024Druid Aire LLC · Wilmington, DEN3002BDenton Charles W · San Juan, PRN3002CAviation By Gosh LLC · Burlington, TXN3002MHarth Kai H · Manassas, VAN3002QJaeger Christopher E · Normandy Park, WAN3002WRio Concho Aviation Inc · Weatherford, TXN3002YGiefer Brett T · Nicollet, MNN3002ZKirkendall James Allen · N Richland Hills, TXN30033Mission Aviation Training Academy · Arlington, WAN30038Stockyard LLC · Wilmington, DEN3003AJwb Three LLC · Cat Spring, TXN3003BEhrlich David · Chico, CAN3003DRoach James M · West Bountiful, UTN3003ETuskegee Airmen National Historical Museum · Detroit, MIN3003FHassinger Farms LLC · Cove, ORN3003KPayne Michael E · Woodlawn, ILN3003L310-J Enterprises Inc · Parkland, FLN3003QTampa Bay Aviation Inc · Clearwater, FLN3003ZPennewell Ollie L III · Monroe City, MO
Back to AD 2007-04-19 R1