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.
N92816Van Cleve G Steven · Windermere, FLN9281GRuffner Scott A · Luray, VAN92822Roada Inc · Indio, CAN92824C182 Wv LLC · Charleston, WVN9282TCloud 9 Aviators LLC · Anchorage, AKN92836Clark Wyatt · Ione, CAN9283GTexas Forever LLC · Denver, CON92843Roehl John F Jr · Neapolis, OHN92844Smooth Sailing Flying Club Inc · Avon, INN92846Evans Millard D · Mobile, ALN92850Nelson Tabor K · Corona, CAN9285XBlu Kaya LLC · Austin, TXN92866Green Edward L · Chico, TXN9286CQueen City Flying LLC · Helena, MTN9286XRogne Fred A · Fallon, NVN9287GCook Lynn H · Highland, UTN92881Patton Aviation LLC · Billings, MTN92887Butler Aircraft Company · Walla Walla, WAN9288CChase Michael D · Albuquerque, NMN9288GPupkar Stephen B · Brookeville, MDN92895Dana Eric B · Davidson, NCN9289GBolands North Inc · Binghamton, NYN9289XFull Send Aviation LLC · Fairview, TNN928CPCivil Air Patrol · Maxwell Afb, ALN928JCLatimer Nelson R · Oxnard, CAN9290GPhillips Richard L · Vienna, OHN9290XPetrich John W · Metaline Falls, WAN9291Henderson Charles B · Houston, TXN92912Hill Charles W · Russellville, ARN9291CMadland Patrick S · Anchorage, AKN92922Perron Matthew B · West St Paul, MNN9292GDarter Lloyd R · Mountain Grove, MON92938Haney Christopher · Murrieta, CAN9293CHayes Dennis Paul · Des Moines, IAN9293XRod Ricky L · El Cajon, CAN9294CBoulder Valley Aviation Inc · Boulder, CON9295CLesmeister Dean J · Kindred, NDN9295TViking Custom Builders Inc · Anchorage, AKN9296CDinstel Delbert F · Park City, MTN9296GGreen Daniel C · Cedar Hill, TNN9296XJasuma Farms · Maxwell, CAN9297TSutton Aircraft Salvage LLC · Palmer, AKN9297XJohnson Durwood D · Beaumont, TXN9298GA&A Aviation LLC · Mountain Brk, ALN929AEColman Steve · Alamosa, CON929FRacoon Aviation LLC · San Antonio, TXN929PMRegistered aircraftN929RHJohnson Merlin K Trustee · Mentone, CAN92ATBroquet Bruce L · Anchorage, AKN92CMN92cm LLC · Genola, UT
Back to AD 84-10-01 R1