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.
N9291FHealey David A · Hammondsport, NYN9291HDawson William F Jr · Port Hueneme, CAN9291JMidwest Aero Club Inc · Omaha, NEN9291KNeff Brandon L · Emporia, KSN9291RBobo Richard H · Okolona, MSN9291VHutchens David R · Pikeville, KYN9291WFarleman LLC · Aurora, OHN9292HBlackhawk Flying Club Inc · Rockford, ILN9292LRegistered aircraftN9292MAkro N9292m LLC · Lighthouse Point, FLN9292QRegistered aircraftN9292ZAbrams Perry · Palmer, AKN92934Service Oriented Aviation Readiness (Soar) · Bolivar, MON9293BCludy Skies LLC · Wildwood, MON9293JChaldu Ronald S · Oswego, NYN9293KYakel Donald L Jr · Springfield, ILFirst renewal noticeN92945Fla Inc · Wilmington, DEN92949Prouts Travel LLC · Wilmington, DEN9294BHall Justin E · York, NEN9294NCmhw LLC · Memphis, TNN9294QPlane Training LLC · Rapid City, SDN9294VMulligan Sean S · Kitty Hawk, NCN9294WBorkowski Brian L · Irwin, IAN9295DStanford Jay H · Anchorage, AKN9295HMiami Seaplane Tours Inc · Miami, FLN9295SSteadman John Harold · Santa Clarita, CAN9295VSt Denis Robert G · Lake City, FLN9295WH&H Aircraft LLC · Scottsbluff, NEN9296HSmith Richard A · Burnsville, MNN9296JAlpha Kilo Aviation LLC · Wasilla, AKN9296LTrites Henry E · Granville, OHN9296SShindel Mark · Los Gatos, CAN9296VOswald Paul C · Shohola, PAN92970Elizabeth City State University · Elizabeth City, NCN9297C831 Aviation LLC · Salinas, CAN9297MBowers Matthew Monroe · Dayton, NVN9297SNovak David J · Hortonville, WIN9297WTorrey Robert E · Pleasant Hill, CAN9297YHart Linda B · San Antonio, TXN9298JSt Pete Aviation Services LLC · Saint Petersburg, FLN9298LLangenberg Stewart M · Santa Barbara, CAN9298PBlackhawk Airventures LLC · Wilmington, DEN9298SQuality Aviation Inc · Atlanta, GAN9298VJones Eric S · Tucson, AZN9298WUniversal Avn Inc · La Cygne, KSN9298ZFrederick Ag LLC · Humboldt, KSN92995Yoanna Flight School Inc · Fort Myers, FLN9299BBird Acquisition LLC · Phoenix, AZN9299JLucas Steven R · Canton, OHN9299LKing Angela · Raleigh, NC
Back to AD 81-18-04 R2