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.
N424ADSky West Aviation Inc Trustee · Albuquerque, NMN424CBLesnett Robert G · Novato, CAN424DDMaple Aviation LLC · Big Fork, MTN424NTLattin Travis · Beloit, KSN424PSRegistered aircraftN424STMisto Louis III · Westerly, RIN424TRCovin Equipment LLC · Arlington, TXN42504Dent Michael Otha · Lake Wylie, SCN42510Skylane 42510 LLC · Moses Lake, WAN42514Tillison Michael W · Cameron Park, CAN42518Thomas Raymond N · Springfield, SDN42519Cruse Chancy Q · Clarendon, TXN42520R & D Aero LLC · Midlothian, TXN42521Coutrney Joseph · Livingston, LAN42525Titus Daniel A · Batavia, OHN42526Stanley Gerald L · Littleton, CON42536N B B S LLC · Kansas City, KSN42538Walled Lake Flying Club · Waterford, MIN42539Lincoln Sport Parachute Club Inc · Lincoln, NEN42543Browne Hunter J · Woodacre, CAN42546Hogue Patrick L · Paso Robles, CAN42549Schutz Christopher J · Rock Springs, WYN42550Byerley Mark S · Greenback, TNN42554Cagle Kimberlee S · Houston, TXN42556Quality Contractors LLC · Deary, IDN42560Mallory Mark P Trustee · Independence, ORN42564Williams Robert E · Clermont, GAN42565Pops Space LLC · Luther, OKN42567C & T Aviation LLC · Seattle, WAN42572Modi Yogini · Homestead, FLN42576Larch Hill Laboratory LLC · Earlville, NYN42577Buttered Landings LLC · Hutchinson, KSN42578Hodges James M Jr · Manchester, GAN42580Cox Bruce R · Brock, TXN42589Haas Kile B · Monette, ARN42591Mcferrin Clinton J · Kyle, TXN42594Wunsch Larry K · Fond Du Lac, WIN42599Avco Patrol LLC · Lyndon, KSN425EJCity Of Portland · Portland, ORN425KAHerrmann Laura Jean Trustee · Saint Bonifacius, MNN425KPBrown David B · Cumberland, VAN425MBPauls Valley Fly Boys LLC · Davis, OKN425PKGood Flight LLC · San Luis Obispo, CAN425PRHorizon Technical Services Inc · Farmingdale, NYN425RBAkguc Cengiz · Lantana, TXN425TASkyhawks Inc · Westminster, CON42604Lawrie Daniel A · Mesa, AZN42606Ramon Jose J · West Palm Beach, FLN42610Meadows Marcus · Anchorage, AKN42615N42615 LLC · Shorewood, IL
Back to AD 84-10-01 R1