AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N59DTN59dt Inc · Malabar, FLN59EAHorizon Aviation LLC · Brooks, GAN59EEKern Raymond L · Bedford, INN59EFTancredi Andrew D · Germantown, TNN59FBCox Steven D · Evergreen, CON59FDPollux Aviation Ltd · Wasilla, AKN59FFPeregrine Howard Partners II Lp · New Orleans, LAN59FSRegistration Pending · Yazoo City, MSRegistration pendingN59GFFisher George A · Earleville, MDN59GRTkaczyk Gary J · Canton, MIN59GTMarianas Mission Aviation Inc · Tamuning, GUN59HYRitter Mark C · Austin, TXN59JAHare Michael R · Nye, MTN59JHFlying Circus Pictures · Los Angeles, CAN59KBBond Kent F · Woods Cross, UTN59KCSouthern Aircraft Consultancy Inc Trustee · Casper, WYN59LAAlphin Lewis Jackson · Mount Olive, NCN59LGWillig Louis · Penn Valley, PAN59LHSpillman Robert L DBA · Port Orange, FLN59LJL & J Aviation Inc · Atwater, CAN59LPHalkett Blair Ross · Knoxville, TNN59LTHall Morgan R · Los Osos, CAN59LVGreek John W · Tustin, CAN59MSSojka Michael J · Bainbridge, INN59PGStone Aviation Holdings LLC · Myrtle Beach, SCN59PHSeider Jason · Dallas, TXN59PMPyland Jack · Seagoville, TXN59PPJohnson Monte W · La Porte, INN59RBRegistered aircraftN59RHSmith Mikeal A · Acton, CAN59RVNghiem Daniel · Westminster, CAN59SMChandler Ronald J S · Tucson, AZN59SRRaeder James · Caldwell, IDN59SWLg Services LLC · Chino, CAN59TPeters Willie W · Brownfield, TXN59TDDavison Terry W · Melba, IDN59TPRegistered aircraftN59TWAb Prop Plane II LLC · Metairie, LAN59VLKelley Aircraft LLC · Weyers Cave, VAN59WBWhiskey Bravo LLC · Scottsdale, AZN59WDHorner Michael W · Manakin Sabot, VAN59WLHerrmann Mark D · Dillingham, AKN59WMHudson River Wings LLC · Montclair, NJN59WYHat Trick Aviation LLC · Coeur D Alene, IDN59YLPanariello Gary F · Sausalito, CAN59YYBay Richard P · West Jordan, UTN5AASimanski Charles J · Onley, VAN5ADCraig Philip A Jr · West Richland, WAN5ARCraig William O · Holland, MIN5AUCrosswind Aviation Of Oklahoma LLC · Stillwater, OK
Back to AD 81-18-04 R2