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.
N5UBWynne Brian P · Reston, VAN5UZRick Aviation Inc · Newport News, VAN5VTEmaaduddin Mohammed · Yonkers, NYN5VYFeatherstone Tony W · Denton, TXN5WDSonoma Valley Aircraft Inc · Vineburg, CAN5WKEz Air Inc · Wilmington, DEN5WPPhagan Loyce W · Waterford, MIN5WUDiamond West LLC · Walnut Creek, CAN5WWClark Nikita C · Ontario, ORN5WXCanard Aviators Inc · Novi, MIN5XA47 Yankee LLC · Bellaire, MIN5XJOmalley Theodore J · Willow, AKN5XWLewis Everett D · Comfort, TXN5YPMo'S Ventures LLC · Lakeside, CAN5YTKilian Jacob J · Anchorage, AKN5YXRed Arrow Aviation LLC · Santa Teresa, NMN5ZMDakota & Skyy LLC · Louisville, CON5ZQHigher Powered Racing LLC · Port Saint Lucie, FLN5ZURegistered aircraftN5ZWVinnola Bruce L · Glenrock, WYN60003Faucette Douglas R · Fallon, NVN60007Haynes Kevin Wayne · Pompano Beach, FLN6000BYahner William P · Central Square, NYN6000PMoseley Timothy D · Calhoun, KYN6000QInternational Air Services Inc Trustee · Carson City, NVN6000TO'Neill Christopher M · Newark, OHN6000WPort Townsend Aero Museum · Port Townsend, WAN6000ZGillette David A · Monticello, UTN6001DJohnson Scott V · Scottsdale, AZN6001HHolmes Robert · Pittsgrove, NJN6001KAllred Warren D · Marshfield, MON6001PZarate Roger L · La Mirada, CAN6001QCurry Gary · Everett, WAN6001RSorbi Aviation Inc · El Cajon, CAN6001VNational Aviation Academy Of Mississippi Inc · Clearwater, FLN6001YPilots Choice Aviation Equipment Leasing Co · Georgetown, TXN6002CChristiansen Aviation LLC · Wilmington, DEN6002KJet & Rotor Aviation LLC · Sacramento, CAN6002LBadawi Aviation LLC · Orlando, FLN6002MDisilvestro Steven G · Wallkill, NYN6002SSouthern Adventures Inc · Stuart, FLN6002WPeppas George D Jr · Fort Wayne, INN6003CMiles Darren · Bonita Springs, FLN6003QOsborn John W · Cimarron, KSN6003RRemikin I LLC · Naperville, ILN6003USoarin Seven Aviation LLC · Morton, ILN6003WCarmon Walter A · Highland, NYN6003XB&E Leasing LLC · Dubuque, IAN6003YAri Ben Aviator Inc · Fort Pierce, FLN6003ZPetranek John A · Mandeville, LA
Back to AD 81-18-04 R2