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.
N6098BMarranca James · Buffalo, NYN6099BWilson Stuart · North Franklin, CTN6099FTreat Gary DBA · Yakima, WAN609PCKoufi Airline Inc Trustee · Wilmington, DEN609RLT And B Mgmt LLC · Las Vegas, NVN60MWArt & Carolyn Inc · Winter Park, FLN60PKWexcap Leasing LLC · Centerville, UTN60QMcleod Cecil H · Mt Pleasant, SCN60WRadisch Herbert R Jr · San Diego, CAN60XMAircraft Partner N60xm Dst · Wilmington, DEN6100BParas Mark J · Camas, WAN6100FTri Rotor Spray & Chemical · Ulysses, KSN6100YRamsay Allan Trustee · Modesto, CAN6101BRegistered aircraftN6103NRed Leasing LLC · Juneau, AKN6103RAta Auto Service Inc · Wilmington, NCN6103SJohnson Robert J · Santa Barbara, CAN6104ULavy Brothers Farming · Biggs, CAN6105FShaw Christopher S · Porterville, CAN6105SMy Sky LLC · Hays, KSN6106BBeck Brooks R · Spearman, TXN6107EDelta-V Ceramic Technologies Inc · San Jose, CAN6108BBuchner George E · Nye, MTN6109BTony Flies Inc · Sparta, NCN6109RBas Part Sales LLC · Greeley, CON610AGObr Leasing · Bristow, VAFirst renewal noticeN610HMGadberry & Graham Inc · Baton Rouge, LAN610KCU S Imaging Flight Ops LLC · Bartow, FLN610MVCsc Delaware Trust Co Trustee · Wilmington, DEN610SLTen Hi Flyers Inc · Denver, CON61105Dorsey Sage · Bend, ORN6110BRansom Bradley D · Flagstaff, AZN6110FKilmer Scott D · Fort Pierce, FLN6111NMcgyver Airshows LLC · Wilmington, DEN6112ABarreto Manufacturing Inc · La Grande, ORN6112FPcb Inc · Paradise, CAN6112SHall Metal Corp · Fort Pierce, FLN6113FOrmsby Engineering & Aviation LLC · Georgetown, INN6114RJstream Lc · Sheridan, WYN6116RAirxn LLC · Williams, AZN6116YSaab35 Draken Inc · Pocono Pines, PAN61170Rusty Pilot Holdings LLC · Citrus Heights, CAN6117EViveros Ezequiel · Calexico, CAN6117FBahl Lawrence S · Lottsburg, VAN6117NTaylor Willis P III · Suffolk, VAN6119ABrender Ronald F Trustee · West Lafayette, INN6119BHeart Mountain Aviation Services LLC · Knoxville, IAN611CCTjc Productions LLC · Ogden, UTN611GDufriend Daren P · Payson, AZN611HPFlorida Highway Patrol · Tampa, FLFirst renewal notice
Back to AD 84-10-01 R1