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.
N9467CDominy Alan L · The Woodlands, TXN9467DHahn Randal N · Wasilla, AKN9467LFanego David · Cape Coral, FLN9467WHartshorn Brian · Waynesville, OHN94682Flight Trainer LLC · Wilmington, DEN94684Delta State University · Cleveland, MSN94688Lyon Aviation Inc · Pittsfield, MAN9468DKelly Henry Searles · Ossining, NYN9468FColeman Harold D · Pikeville, KYN9468HShouse Andrew · Flagstaff, AZN9468JSheffield Glenn A · Houston, TXN9468LGa N9468l LLC · Atlanta, GAN9468PSmall Alan J · Bristol, RIN9469DRanney Gayle · Cordova, AKN9469EParker Duane E · Louisville, KYN9469HAirplanes And Attitude LLC · Mckinney, TXN9469JNelson Stephen A · Milaca, MNN9469LButler Mark E · Texarkana, TXN9469VNorton Curtis S Jr · Beaver Falls, PAN946AKotranza Robert R · Houghton Lake, MIN946ACNaples Air Center Inc · Naples, FLN946AFDuke Kay L · Darrouzett, TXN946BWhiteside William E · Talmage, CAN946BDBeede Curtis M Trustee · Maineville, OHN946BVAnton Bill · Satanta, KSN946CCBrown C C · Laramie, WYN946CHCritchfield Flying Service LLC · Rupert, IDN946CPCivil Air Patrol · Maxwell Afb, ALN946CVLightcap Michael Wayne · Mc Alpin, FLN946GSStage George A · Kirtland, OHN946MSMt San Antonio College · Walnut, CAN946PMMorgensen John D · Prescott Valley, AZN946PTBrillo Benjamin G · Union City, CAN946RHMorcom Aviation Services Inc DBA · Everett, WAN946SFSnohomish Flying Service Inc · Snohomish, WAN946SMEntrekin David C · Ridgeland, MSN946TEStrange Bird LLC · Hackensack, NJN946THWingsleasing LLC · Wichita, KSN9470DJacko Josh E · Anchorage, AKN9470WRegistration Pending · Cortez, CORegistration pendingN94714Wright Aero Inc · Saint Cloud, MNN9471CHitpas Henry R II · Beaufort, SCN9471DRasmuson Travis R · Helena, MTN9471VJ S Alguire Consulting Forestry Services Inc · Dover, DEN9471WMidway Enterprises Inc · Wilmington, DEN9472FJunell Sonny Brian · Midlothian, TXN9472HMulder Terry A · Appleton, WIN9472JMarquette County Flying Club · Marquette, MIN9472LBradt Jeffrey A · Charlton, NYN9472WSelvaraj Mylappan · Butler, PA
Back to AD 81-18-04 R2