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.
N65999Vaughn Thomas N · Shallowater, TXN6599MSieben Livestock Co · Helena, MTN659BPArnold Airplane LLC · North Branch, MNN659SDCall David A · Carson City, NVN65AMDorroh Frederick A · Ardmore, OKN65BLWhite Craig S · Troy, OHN65CFSanders David T · Flagstaff, AZN65DWNorth Stream Capital LLC · Scottsdale, AZN65FDBarnstormer Leasing LLC · Murfreesboro, TNN65KCBarr Air Patrol LLC · Mesquite, TXN65KSSauceda Juan B · Austin, TXN65MPWard Gerald · Austin, TXN65NOlterman Robin L · John Day, ORN65PKOlson'S Excavating Inc · Cascade, IDN65RHHall Robert · Rapid City, SDN6600XBlanton David L · Valley Center, KSN6601MOptical Aviation LLC · Edmond, OKN66021Mcgraw Leasing LLC · Sitka, AKN6602CSnip Robert C · Telluride, CON66033Schwarz Wesley E · Ovalo, TXN66034Shaffer Mark N · Ocala, FLN6603UN6603u LLC · Albuquerque, NMN66040Sierra Auto Recycling Inc · Ridgecrest, CAN66041Wof Investments LLC · Dover, DEN6606YBlackwell Benjamin D · Scottsdale, AZN66070Obetz Robert S · Manheim, PAN6608XJancaterino Daniel · Hull, MAN6609CTailwinds 23 LLC · Plymouth, MIN660MRWilson Process Instrumentation Calibrations Inc · Muskegon, MIN660TJmta Management LLC · Clinton, MON6610RSonday Terrance · Spring, TXN6610XJason Bullard LLC · Star City, ARN6611MUsda Forest Service Fepp · Columbia, SCN6611XNelson Ann · Box Elder, SDN66128Mcgowan Walter R · Gold Hill, ORN66135Miller Robert · Pierpont, OHN6613XPeery Robert C · Burns, TNN6614MSky West Aviation Inc Trustee · Albuquerque, NMN6614YBoots LLC · Clay Center, KSN66156Mount Crillon LLC · Juneau, AKN6617CN6617c Inc · Calumet City, ILN66182Naples Seaplane Adventures LLC · Denmark, MEN66186Rybak David J Sr · Lino Lakes, MNN6618XRoark Ken W · Cisco, TXN6619XMartin Kevin · New Carlisle, OHN661KBBaldeo Kessho I · Bay Shore, NYN661SFSierra Foxtrot Ltd · Glen Ellyn, ILN66202Biggerstaff Connie J · Stanford, MTN6621AJc Investors Group LLC · Coral Springs, FLN66226St Cyr Shane · Plattsburgh, NY
Back to AD 84-10-01 R1