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.
N9112LRockey Bruce G · Bitely, MIN9112WCherokee N9112w LLC · Boise, IDN9112ZWalters Darren · Overland Park, KSN9113LZimin Carl E · Naknek, AKN9113VBarry Dustin Michael · Highland, ILN9113WFlying Magic LLC · Post Falls, IDN9114DMacair Aviation LLC · Xenia, OHN9114EParkerson Stanley L · Fairbanks, AKN9114HRohwer Michael G Trustee · Tucson, AZN9114JRouss Charles F · Martinsburg, WVN9114LKeller Crop Surveillance LLC · Jonesboro, ARN9114TFlying Frog Aviation LLC · Palm City, FLN9114VTayl Number Aero LLC · Tontitown, ARN91150Itsacinch Inc · Mer Rouge, LAN91151Dagnon Scott R · Bozeman, MTN91154Ellingson Daniel E · Stuart, FLN9115DRoods Shawn R · Billings, MTN9115FMccaffree Andrea J · Shepherd, MTN9115LSavonen Stephen D · Ukiah, CAN9115QSoto Daniel-Rey · Smiths Station, ALN9115VBovo Paolo · San Benito, TXN9115ZK & C Publications LLC · Spring Valley, OHN91160Brown Jeffrey C · Saint Augustine, FLN9116DPeterson Lauren R · Anchorage, AKN9116JPolcyn Matthew D · Millersburg, OHN9116LShowers Of Blessings LLC · Fredericktown, MON9116TSkinner Jay D · The Woodlands, TXN9116WKoury Michael Jacob · Fort Mohave, AZN9116ZIron 17 Investments LLC · Mount Pleasant, TXN9117Runnels James A · Dublin, TXN9117CRegistered aircraftN9117LWillkris Aviation Services LLC · Smithfield, VAN9117QBenson Joshua J · Winchester, CAN9117VEdgerton Bruce M · Ottsville, PAN9117WLittle Wing Aero LLC · East Longmeadow, MAN91187Usda Aphis Ws Atoc · Cedar City, UTN9118CWalter Tina R · Yorkville, CAN9118DYaggie Equipment LLC · Breckenridge, MNN9118LDavis Brett M · Madison, MEN9118SSt Pete Aviation Services LLC · Saint Petersburg, FLN9118WHalford Robert · Troy, TXN9118ZFlying Mermaid LLC · Aiea, HIN9119DArne Blair V · Carpenter, SDN9119JAlex Aircraft LLC · New Albion, NYN9119LPiercy Ronald S · Moses Lake, WAN9119RMiller Robert III DBA · Kittrell, NCN9119TDahab Richard E · Brightwaters, NYN9119VCarlson Tracy W · Henderson, NVN9119WBas Part Sales LLC · Greeley, CON911BUDurante Leonard J · Navasota, TX
Back to AD 81-18-04 R2