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.
N80670Jb Aviation Management Inc · Wonder Lake, ILN80673Mitchell Aviation LLC · Mitchell, SDN80678Aero Maintenance Inc · Vancouver, WAN8067DBurgess Bruce A · Saint Johns, MIN8067GMaley Randy J · New Philadelphia, OHN8067NCsp Avionics LLC · Knoxville, TNN80684Domino Adam P · Saint Petersburg, FLN8068CThunderbird Aircraft Company · Bloomington, MNN8068GStructural Design And Analysis Inc · Reston, VAN8068JGo Vertical Aviation LLC · Russellville, ALN8068WRkd Flier Inc · Nemaha, IAN8068ZBasco John J · Pottstown, PAN80690Flight Foundation · Unicoi, TNN80692Registered aircraftN80697Moe-Air LLC · Cincinnati, OHN8069AInfinity Aviation St Cloud LLC · Rice, MNN8069DCasey Michael B · Hemingford, NEN8069NRajski Douglas S · Freeburg, ILN8069PNw Contract Services LLC · Graham, WAN8069WAdventures In The Sky Aviation LLC · Fresno, CAN806ATFlight School Of Texas LLC · Wilmington, DEN806BBNoyes Jimmy D · Fruitland, IDN806CInternational Divers Co Inc · Corpus Christi, TXN806CPCivil Air Patrol · Maxwell Afb, ALN806CWWilling John W · Grove City, OHN806DAPeak Leasing LLC · Anchorage, AKN806EHFisher Air LLC · Cardington, OHN806ERDiamond Aircraft Sales Of Kentucy LLC · Henderson, KYN806FTJohnson Daniel S · Louisville, KYN806GPPractical Educators Association · Amelia, VAN806HAFlywell Aviation LLC · Bowling Green, KYN806NVFlight Operations Inc · Lewes, DEN806RRIsland Flights Inc · Wilmington, DEN806RVPastorek Jordan M · Frisco, TXN806SPAir Marion Inc · Marion, INN806TDWall Joseph J · Chamberlain, SDN806THFvx Research · Bristow, VAFirst renewal noticeN8070Farrington Andrew J · Shelton, WAN80700Changes In Latitude LLC · Kingwood, TXN8070CKnutson Wayne R · Tioga, NDN8070PDowns Steven M · Camden, TNN8070UMartin Jack W Jr · Dublin, GAN8070WMordini Robert D · Grand Marais, MNFirst renewal noticeN8071GBell John · Queen Creek, AZN8071LRogers Jonathan T · College Place, WAN8071NFigone David Anthony · Williams, AZN8071PMatherley Frank · Greenbrier, TNN8071SNolan Cynthia M · Rimrock, AZN8071WFernandez Gregory · San Antonio, TXN8071XFlorida Aviation Career Training Inc · Saint Augustine, FL
Back to AD 81-18-04 R2