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.
N8124QMn Badger Aviation LLC · Rochester, MNN8124SBauso Kenneth · Marfa, TXN81250Sanchez Paul K · Boca Raton, FLFirst renewal noticeN81251Winfield John F Jr · Scituate, RIN81259Thermodynamic Sciences LLC · Irvington, ALN8125ANt-Cfp LLC · Baltimore, MDN8125LHillsboro Aero Academy LLC · Hillsboro, ORN8125PIrie Lot LLC · Westminster, CON8125WLynch Ronald · Carson City, NVN8125YGlass Jody L · Indianapolis, INN81260Trusty Archer LLC · Ann Arbor, MIN8126DHackleman Brian K · Rochester, NYN8126EAnderson Wilbur W Trustee · Lead Hill, ARN8126MWest Hawaii Wingers Incorporated · Kailua Kona, HIN8126XB2fh Ltd · Allentown, NJN8127Quimby James N · Bay City, TXN81274Elhaje Tamim · Cypress, TXN8127DTrimmer Marvin E · Willow, AKN8127EFugate Ruth · Riverside, CARegistration revokedN8127HSpradley Nicholas Scott · Northport, ALN8127KAntler Aviation And Wildlife Service LLC · Wasilla, AKN8127PSimpson Peter T · Prides Crossing, MAFirst renewal noticeN8127YDragon Flight Training Academy LLC · Pembroke Pines, FLN8128Kubichek Janet C · Winnemucca, NVN81283Smith Brad R · Sand Springs, OKN8128DBuckner John L · Ragland, ALN8128PScotts Aviation Services LLC · Kalispell, MTN8128WSilver Wings Legacy LLC · Weatherford, TXN8128XSimmons Kenton L · Van Alstyne, TXN8129FHigh Exposure Inc · Wilmington, DEN8129HAdventure Bound LLC · Saint Paul, NEN8129JFunk Wendell L · Lancaster, PAN8129MAviation Consulting Expertise LLC · Fairfax Station, VAN812ABHarr Carl D · Mc Alpin, FLN812AFState Of Louisiana · Baton Rouge, LAN812ATHaverlah Dennis W · Cedar Park, TXN812BBAlexander Matthew J · Cumming, GAN812BSSb3 Asset Management LLC · Gilbert, AZN812CHKragenbring Brandon Jon · Lake Lillian, MNN812CPHigh Wing Air Services LLC · Merritt Island, FLN812DDcc Aero LLC · Alamosa, CON812DAHanson Aviation LLC · Winter Park, FLN812DDMeans James M · Maryland Heights, MON812DJDelaware Air LLC · Dover, DEN812EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN812JBKrall Jeff P · Mitchell, SDN812JSAmsden Max L · Hazen, NDN812KSUniversity Of Central Missouri · Warrensburg, MON812LLee Myles W · Erie, CON812LDRegistered aircraft
Back to AD 81-18-04 R2