AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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.
N427WYMayes Neil M · Lovell, WYN42801Aas LLC · Ovid, MIN42804N42804 LLC · Brush, CON42818Cleveland Jeffrey Allen Trustee · Indian Trail, NCN42820Cordobesa Aviation LLC · Belgrade, MTN42823Acs Products Co · Lake Havasu City, AZN42826Aero Elite Inc · Wilmington, DEN42831Shuff James S II · Victor, WVN42849Moonrise Soaring Inc · Wilmington, DEN42851Emmons Steven · Russellville, ARN42852Fisch Kurt D · Riverside, CAN42855Wojteczko Jason A · Derby, KSN42858Younggren James H · Hallock, MNN42865Skylane Partners LLC · Duvall, WAN42871Registered aircraftN42874Kloker Daniel E · Owasso, OKN42875Bowes Tyler D · Fremont, OHN42876Norcal Flight Center LLC · Lincoln, CAN42877Allain Patrick C · Brusly, LAN42887Bratlien Michael D · Aurora, CON42888Ahigian Craig S · Laguna Niguel, CAN42889Fuller Lawrence A · Wasilla, AKN4288PMooradian Edward M · Fowler, CAN42893Registration Pending · El Paso, TXRegistration pendingN42894Comal Aero Inc · Schertz, TXN42898Perera Austin L · Barnstable, MAN42899Smith Charles Max · Canon City, CON428BLFlying Money Pit LLC · Des Moines, IAN428HSSchroebel John Daniel Trustee · Pleasant Hill, CAN428LBMam Aviation LLC · New York, NYN428MTNby Productions · Manassas, VAN42907Albion Telephone Co · Albion, IDN42911Kenney Stuart C · Atlanta, GAN42912Forouzan Fardad Trustee · Poway, CAN42916Nedwick Lars I · Girdwood, AKN42919Tarnutzer Aviation LLC · Wayland, MIN4291QRegistered aircraftN42941Nistler Steve W · Helena, MTN42947N42947 LLC · Panama City, FLN42949Niemeyer Donald C DBA · Hobart, INN42951Tiedt Randy · Parkville, MON42955Brown Donald E Jr · Jonesboro, ARN42958Havasa Enterprises LLC · Sisters, ORN42967Brook Daniel L · Marshall, INN42968Jelinek Spencer T · Erie, CON42972Anderson Mike D · Mc Alpin, FLN42974Tracy Lanning Construction LLC · Westminster, SCN4297547q LLC · Eau Claire, WIN42980Friday Dale C · Santa Cruz, CAN429DLLandset David J · West Palm Beach, FL
Back to AD 84-10-01 R1