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.
N3270DMcbride Robert W Jr · Cedar Park, TXN3270UScott Brian W · Sagle, IDN3271UDallas Avionics Inc · Dallas, TXN3271YWoodbury Ivan D · Bowling Green, OHN3272YOlsen Chris M · Othello, WAN3273SHepfer John E DBA · Midland, TXN3274DMcroberts David M · Washoe, NVN3275CMoore Hazel Grace · Boise, IDN3275DCrystoff James J · Kodiak, AKN3276DFarkas Jonathan · Mukwonago, WIN3276SLewinsky Marlon · Carrollton, TXN3276UNk Innovations LLC · Spokane, WAN3277CSandstrom Mark R · Minot, NDN3277SBayless Smoky · Coronado, CAN3277YLapinsky Richard G · Los Lunas, NMN3278SStrong Brian S · Southport, NCN3278UCarver Thomas G · St Maries, IDN3279CHunsucker Michael A · Seguin, TXN3279DDavies James E · Eagle, IDN3279NTips Frederick J III · San Antonio, TXN3279USchlafmann Jay R · Mercer, NDN327BWCessna N327bw LLC · Telluride, CON327CTYr-Aircraft Leasing LLC · Bethel, AKN327DMMullin Clint · Lambert, MTN327GHTextron Aviation Inc · Wichita, KSN327HRRd Holdings LLC · Las Vegas, NVN327KMarsh John E · Washington, DCN327LSHeermann Philip D · Albuquerque, NMN327LWPerini Stephen Dale · Fayetteville, GAN32806Nimsic Thomas L · Carson City, NVN3281DRichardson John David · Willis, TXN3281SWright Flyers Club · Huber Heights, OHN3282DLafleur Kerry P · Fort Worth, TXN3282SWest Thomas Edward · Watsonville, CAN3283DAllen Roger B · Gardnerville, NVN3284DKornfield Edward A · Anchorage, AKN3284YMonnin Cass C · East Wenatchee, WAN3285SCastro Manny H · Tucson, AZN3288DSmith James O · Montgomery, TXN3288SEpple William E · Roggen, CON3288UVetch Rod F · Ranchester, WYN3289SDouble Lazy H LLC · Delta, CON3289URutenbeck Terry L · Wiggins, CON3289YHasselbring Ted S · Nashville, TNN328CACivil Air Patrol · Maxwell Afb, ALN328LDuffield Brian · Eastvale, CAN32909Zamarripa Hector · Brownsville, TXN3291SRegistration Pending · Highland, ILRegistration pendingN3292UAnnecchini Frank C Jr · Overland Park, KSN3293DGuilliams Carl · Gilbert, AZ
Back to AD 84-10-01 R1