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.
N9159VSmith Darryl Edward · Houston, TXN9159WDodson International Parts Inc · Rantoul, KSN915AJb Efta Farms Inc · Argyle, MNFirst renewal noticeN915AAHoecher Robert T · Anchorage, AKFirst renewal noticeN915AFAmeriflyers Of Texas Inc · Addison, TXN915AZN915az LLC · Miami, FLN915CMVaayu Aviation LLC · Newark, CAN915CPCivil Air Patrol Inc · Maxwell Afb, ALN915DAb Prop Plane II LLC · Metairie, LAN915DDWest Michigan Aviation Academy · Grand Rapids, MIN915GArcher Flight LLC · Wilmington, DEN915GWWills Gary W · Channahon, ILN915HPAnderson Austin C · Washington, DCN915JBKruger Karl A · Monterey, TNN915JCCannata Jack P · Roselle, ILN915JDDowling Jeffrey T · Poplar Grove, ILN915KKKramer Kurt J · Volcano, CAN915LCardinal Flying Corp · San Jose, CAN915LFLingo Joshua B · Oak Grove, LAN915LSBlack Bear Aviation LLC · Camden, DEN915MBBarras David G · Breaux Bridge, LAN915NCMiller Nevin D · Naples, IDN915PSmith Jr Franklin R · Rock Hill, SCN915PABird Acquisition LLC · Phoenix, AZN915PBLease Lawrence · Royal Oaks, CAN915RDDavis Richard L · Kenai, AKN915RSHayward Houston C · Lansdale, PAN915RVWiegand Jeffrey L · Ocean Isle Beach, NCN915TAAurora Aircraft LLC · Waterford, MIN915TTLake Elmo Aero LLC · Lake Elmo, MNN915WBBordelon Warren P · Breaux Bridge, LAN915WMChambers David N · Cullman, ALN915WVSmith Aviation LLC · Springer, OKN9160DMalsby Thomas H · Blairsville, GAN9160HTodd Media Inc · Tuscaloosa, ALN9160JMohan Aditya · Rancho Cordova, CAN9160VLangis Maximus · Newburyport, MAN9160WAmerican Aviator LLC · Arlington, TXN9161FHuie John E · Burnet, TXN9161HAir Athens LLC · Athens, GAN9161JNortheast Nebraska Aviators Inc · Wayne, NEN9161SCarr Jack Willson · East Lansing, MIN9161TMenagerie Enterprises Inc DBA · Denison, TXN9161VKaroki Jonah · Strasburg, CON91622Utterback Karl D · Fort Wayne, INN9162HStratus Aviation LLC DBA · Vacaville, CAN9162JHillelson Lawrence E · Grosse Ile, MIN9162NMann Aviation LLC · Wilmington, DEN9162WYanka Anthony Joseph · Moorestown, NJN91631Seale Taylor Edward · Madison, WI
Back to AD 81-18-04 R2