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.
N21207Burgess John H · Tower, MNN2120CQuilter Charles J II Trustee · Laguna Beach, CAN2120FWare Brandie W · Nikiski, AKN2120GSouthern Arizona Balloons Inc · Tucson, AZN2120ROda Mark E · Angola, INN2120ZHenry John M · Anchorage, AKN21215Van Steenkist Grant · Spokane Valley, WAN21219Dubose Brian · West YorkshireN2121GSutton Aircraft Salvage LLC · Palmer, AKN2121LDl Contractors Inc · Rexburg, IDN2121RDengler Phillip L · Bordentown, NJN2121XTaylor Commercial Properties LLC · Jackson, TNN2121ZRegistered aircraftN21224Registration Pending · Brenham, TXRegistration pendingN21227Fly21227 LLC · Charleston, WVN2122CIrwin Dennis R · San Diego, CAN2122SBobo Construction LLC · Pullman, WAN21230Beggs Construction Inc · Salem, ORN21236Gjedde David C · Morristown, TNN21238Hatfield Derik L · Mesa, AZN2123CZeiner Ty R · Marion, KSN2123EDream Flights LLC · Brewton, ALN2123GCasten Scot R · Vernonia, ORN2123NKangas Brian Alfred · Houghton, MIN2123RHowell William J · Incline Village, NVN2123YPalin Investments 3 LLC · Vancouver, WAN2123ZGauntt Chep R · Pasco, WAN21244Connors Geoffrey M · La Center, WAN21247Registered aircraftN2124CSutliff Larrie G · Briarcliff Manor, NYN2124GSilicz Alexander Nicholas · Shafter, CAN2124RKokjer Kenneth J · Fairbanks, AKN21251De La Fuente Rene M Trustee · Yorktown, VAN21254High Wing 182 LLC · Lenoir City, TNN21257Stc Aviation Services LLC · Logan, UTN2125ACable Thomas G · Rockford, MIN2125CFroes Jonathan · Avondale, AZN2125RHogue William B Jr · Simi Valley, CAN2125ZStone Michael D · Boise, IDN21260Airborne Athletics Inc · Bloomington, MNN21268Aufderhar Kenneth G · Lopez Island, WAN2126GSmith Jonathan R · Waxhaw, NCN21271Barnett Ryan M · El Reno, OKN21274Quax LLC · Wallkill, NYN2127FBrice Adam R · Camas, WAFirst renewal noticeN21281Horne Randall W · Millington, TNN2128GBeckhoff Michael A · Casper, WYN2128RCreasey Daniel L · Arnold, MON21291Castleair LLC · Dothan, ALN21297Bradley Robert S M Sr · Rougemont, NC
Back to AD 84-10-01 R1