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.
N9813HDowney Corp · Cornwall, VTN9814GNoble Jeremy · Stanwood, WAN9815AReese Steven A · Shoreline, WAN9815HAnderson Joseph Richard · Lewiston, IDN9815ZSilver Creek Aviation Services · Fort Worth, TXN9816EArizona Air Salvage · Phoenix, AZN9817HBurcham Timothy Scott · Encinitas, CAN98182Bena Christopher D Trustee · Wasilla, AKN9818HFowler Raymond E · Smyrna, GAN9818XPlath James F · Davenport, NDN9819HStanley Aero Club Gastonia Inc · Belmont, NCN981AKState Of Alaska · Anchorage, AKN981MRJlove LLC · Vienna, VAN981RDSunrise Adventures LLC · Stillwater, MNN981SCCarter Brooks LLC · Kalispell, MTN981WBFlying Fortress Of Swfl LLC · Fort Myers, FLN981WMFlying Fortress Of Swfl LLC · Fort Myers, FLN981WSNayrmarc LLC · Linden, MIN98207Perkins Robert T · Anchorage, AKN9820HSeghieri Richard T · Santa Rosa, CAN9821CN5965t LLC · Lehigh Acres, FLFirst renewal noticeN9821ERegistered aircraftN9821HDowning Darrell W · Drakesville, IAN9822ESample John A · Gonzales, TXN9822HPetsche Tim E · Meridian, IDN9822XHultquist Daniel D · Anchorage, AKN9823ADuke Kay L · Darrouzett, TXN9823XTop Hand Inc · Laurel, MTN9824HClimb LLC · Kalispell, MTN9826ADanek Brian C · Morris, ILN9827CKae Aviation LLC · Conover, WIN9828AMitchell Thomas H · Kennewick, WAN9828ETa Wellner Group LLC · Lake Oswego, ORN9828XPathfinder Aero Services LLC · Sheridan, WYN9829ARoy Rodney E DBA · Grand Marais, MNN9829HWright Steven · Shelbyville, TNN9829MRyan Air Inc · Anchorage, AKN982BRThompson H S Trustee · Oakdale, CAN982SFBauermeister Matthew · Lake Tapps, WAN9830XWard Todd · Corona, CAN9832XAlbert Bryan W · Palmer, AKN9833AKreit Kenneth Samuel · Catlett, VAN9833HMccool Air Service Inc · Mc Cool Junction, NEN9834CN8184h LLC · Thiensville, WIN9834XPemberton Ryan A · Valleyford, WAN9835AMcclain Aviation LLC · Roanoke, TXN9836AMabry Dale C · San Antonio, TXN9836CDominguez Robert R · Temecula, CAN9836HDouglas County Land Title Co · Douglasville, GAN9837HChristmas Aviation LLC · Pace, FL
Back to AD 84-10-01 R1