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.
N7880GGhegan John · Wilmer, ALN7880KMattingley Kenneth R · Willow, AKN7880WSefinas Avir LLC · Brooklyn, NYN78819Houdek Dennis E · Roseburg, ORN7881GSmith John T · Greenfield, INN7881WEast Crest Management LLC · Eastvale, CAN78825Houdek Dennis E · Roseburg, ORN78827Latshaw Elizabeth H · Catawba, NCN78828Dotter Henry C · North Pole, AKN7882CKeck Joseph S · Las Vegas, NVN7882PWaters Robert D · Albuquerque, NMN7882VSlepian Isaac J · El Dorado Hills, CAN78830Frederick Wayne Schultz · Bradley, ILN78834Barron Ted L · Hoover, ALN7883DMeierotto Marty · Two Rivers, AKN7883PFinke Michael C · Pleasant Prairie, WIN7883TMarlu Enterprises Inc · Foristell, MON7883VFranks Gary E · Ponder, TXN7883WStack Brian James · Paso Robles, CAN7883YHoward Jerry W · Snellville, GAN78842Helice Sarcelle LLC · San Antonio, TXN78846Aero Investors Lc · Jackson, MIN78850Karpik Richard Paul · Grand Rapids, MNN78856Bedwell Christopher A · Paso Robles, CAN78857Hunt Thornton Trevon · Aurora, CON7885DLindstrom Daniel G · Somerset, WIN7885HFisher Joel F IV · Rockville, MDN7885WCp Authority LLC · Poulsbo, WAN7885YKregel Steven · Garnavillo, IAN78861Wood Jeffrey A · Willis, TXN78865Gingras Carl A · Avondale, CON78869Zullo Thomas L · Lindenhurst, NYN7886GArctic Barnabas Ministries Inc · Kenai, AKN7886VLowenhaupt Michael J · Metairie, LAN7886WChelena Eric D · San Antonio, TXN78871Rosenfeld Kristina M · Eureka, CAN78873Mesner Steven M · Tomah, WIN78875Janssen Christopher R · Ankeny, IAN78877Obrien Garrett G · Sheep Ranch, CAN7887GLandrum Erik · Austin, TXN7887P7887papa LLC · Glenwood Springs, CON7887WDepp Gregory B · Ft Worth, TXN7887YAskins Jack C · Wichita Falls, TXN78880Coma Aviation LLC · Buckhannon, WVN78882Triplat Bonnie E · Rosamond, CAN78884Cooke Daniel S · Kanarraville, UTN78888Woodard Ben C · Truckee, CAN7888MMonpas Mark E · Anderson, CAN7888WLashinski Michael J · Monument, CON7888YBurkel Robert G · Hemet, CA
Back to AD 81-18-04 R2