AD 84-10-01 R1
Registered aircraft · 20,481
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.
N5383XWillard Raymond C · Wasilla, AKN5384BGust Dale A · Boise, IDN5384NBlizzard Johnny F · Lake City, FLN5385HBeer Steve Z · Morristown, NJN5385NTrevino Sergio A · Houston, TXN5385SMcginnis Air LLC · Rising Star, TXN5386ATriplett And Adams Transport Partnership LLC · New Concord, OHN5386BTop Dogs LLC · Dickinson, NDN5388BBurak Steven W · Emmett, IDN5388YValiair Lc Trustee · Casper, WYN5389DRegistered aircraftN538PCFontaine Scott M · Salt Lake City, UTN5390NLarsen Steve J · Colton, ORN5391ASingh Amandeep · Stockton, CAN5391DPope James D · Lewiston, IDN5391TV Y Aviation LLC · Gentry, ARN5393NRegistration Pending · Craig, CORegistration pendingN5393TTinseth Lance D Trustee · Highlands Ranch, CON5394DBruce Gregory L · Yelm, WAN5394XL K Hollenbeak Logging Inc · Hayfork, CAN5395BRosecrans Robert Michael · Emmett, IDN5395DLindberg Thomas W · Anchorage, AKN5395NDelaware Horizon Properties LLC · Lewes, DEN5395VCortez Flying Service Inc · Cortez, CON5396BGreene County Sport Parachute Center Of Ky Inc · Loretto, KYN5399DWeeks Patrick · Anchorage, AKN5399EAerocraft LLC · Durango, CON539MYMiller Aviation LLC · Murfreesboro, TNN53ESSpooner Brent · Fulshear, TXN53EURegistered aircraftN53FVTorres Ramon Luis · San Juan, PRN53KPMateos Louise M · Santa Clara, CAN53MPPie In The Sky Inc · Shreveport, LAN53SGJecker Scott W · San Marcos, TXN53TMSmith Douglas M · Hackettstown, NJN5400BRegistered aircraftN5400VWilson Darryl M · Granger, INFirst renewal noticeN5401AHeadon Richard · Chino Hills, CAN5401NMcmanus Casey J · Edmonds, WAN5401XBarbera Frank M · Edgewood, NMN5402BFiehler Vernon D · Auke Bay, AKN5407BSutton Aircraft Salvage LLC · Palmer, AKN5408BLeonard James A · Boise, IDN5408NAviation Law LLC · Mesa, AZN5409YLee Christopher · Katy, TXN540DCSkylane Aviation LLC · Hazelwood, MON540KMKreuter Engineering · New Paris, INN540RTMorgan Stanley L · Nome, AKN5410BOklahoma Soaring Association · Mustang, OKN5411AMarc Aircraft Holding LLC · Soldotna, AK
Back to AD 84-10-01 R1