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.
N9073LRegistration Pending · Munford, TNRegistration pendingN9073VOlsen Leif C · Richardson, TXN9073WBerg Daryl A · Savage, MNN90743Byrne Matthew A · West Allis, WIN90744Central Virginia Aviation Inc · North Dinwiddie, VAN90748Robinson Helicopter Co · Torrance, CAN9074DHill Russell DBA · Seminole, TXN9074JEast Kentucky Aviation LLC · Ashland, KYN9074LTillotson Bradley T · Loveland, OHN9074VLounsbury Joseph Jr · Palm Coast, FLN90759Kemp Acquisitions LLC · Lone Jack, MON9075LSibbernsen William · Omaha, NEN9075VRankin David W · Bend, ORN9075ZLimbacher Richard A · Stone Creek, OHN90763Apex Aircraft Leasing LLC · Anchorage, AKN90769Registration Pending · Sterling, AKRegistration pending, pending cancellationN9076CEvv Pilots Club Inc · Evansville, INN9076HBeachy Jonas D · Whittington, ILN9076JMidvale Flying Club Inc · Midvale, IDN9076WAircraft Holding Solutions Owner Trustee · Newark, DEN9077Lrh Equipment LLC · Pendleton, ORN90774Miller Lynn H · Scottsdale, AZN90775Dubois Aviation Inc · Chino, CAN9077C389 Fifth Street LLC · Placida, FLN9077DLitzen Guide Service Inc · Kenai, AKN9077JStreuer Troy · Smithville, TXN9077KPacific Coast Aero Inc · Torrance, CAN9077LVeilleux Payton L · Pittsfield, VTN9077WSmith Dwayne · Manassas, VAN90783Rudd Wayne G · Basalt, CON9078DChandelle Ltd · Brighton, CON9078JConner W Larry · Los Lunas, NMN9078VRich Lucas Aircraft Sales LLC · Lincoln Park, NJN9078WWood Trey A · Colorado City, TXN9078YParker Ron L · Melissa, TXN9079DThomas William C · Blanchardville, WIN9079JTestruth Gary R · Coarsegold, CAN9079NFlorida State College At Jacksonville · Jacksonville, FLN9079TLuther David J Trustee · Saint Maries, IDN9079VAbramson Derek J · Lancaster, CAN907AGAntique Aircraft And Automobile LLC · Van Alstyne, TXN907ALTjm Ventures Inc · Rio Verde, AZN907APWheeler David A · Kennewick, WAN907AXNeuman Cort J · Palmer, AKN907AZN907az LLC · Miami, FLN907BPBryant Stephen C · Anchorage, AKN907BTKramer Michael · Talkeetna, AKN907CCOconnor Lloyd Thomas · Dillingham, AKN907CFThumann Wayne E · Weimar, TXN907CPCivil Air Patrol Inc · Maxwell Afb, AL
Back to AD 81-18-04 R2