AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N6684GReeder Brenton Lamar · Beacon, NYN6684HBent James L Jr DBA · Palatine Bridge, NYN6684TButzen Steve B · Sheboygan, WIN6687EDriggers David J · Anchor Point, AKN6687FBlakesley Eric R · Canandaigua, NYN6687SSale Reported · Houston, AKSale reportedN6688APouncey Robert · Proctor, ARN6688TSelfridge Dennis A · Dighton, KSN6689AMaley Christopher L · Otsego, MIN6689EHeizler Mark W · Oswego, ILN6689FMills Nicolas A · Greenwood, NYN6689SSimpson Dwight D · Phillips, WIN6689TFlying Restorations LLC · Holts Summit, MON6690SSeniram Air Inc · Wilmington, DEN6690TAviation Connection LLC · Lake Worth, FLN6691HSills Joseph G · Bastrop, TXN6692EMarshall Jerry J Sr · Parker, AZN6692GHopkins Marissa A · Cameron, MTN6692SNoltensmeyer Kurt Jon · Greenbank, WAN6694ADenslow Carl W · Barto, PAN6694FWanagel Walter · Lisbon, CTN6694GChatas John W · Ann Arbor, MIN6695AStewart Guy C · Stevens Point, WIFirst renewal noticeN6695SOlsen Raymond E · Washington, UTN6695TSischka Nicholas A · Haddon Heights, NJN6696FYoung Deborah C · Lopez Island, WAN6696SJohnson Jay E · Murray, IAN6697AHart David L · Oxnard, CAN6697EMartin Jonathan · Trumann, ARN6697FLogan Thomas H · Canfield, OHN6697GPaul William A · Windfall, INN6698TJeplawy Elizabeth A · Glenwood Springs, CON6698ZPelletier Frederic · Arizona City, AZN6699AAdderley Allan M · Hernando, FLN6699EWheeldon Chancy R · Jackson Hole, WYN6699GBailey Matthew T · Cornelius, ORN6699TFlory Michael Scott · Eldorado, TXN669JKGeddes Michael · Seattle, WAN66BDCampanella Stephen · Brunswick, OHN66CXMack Andrew M · Tehachapi, CAN66DARosman Michael J · Mukwonago, WIN66DCCox Jimmy D · Ft Smith, ARN66DJChapman John R · Kalamazoo, MIN66EZMorley John · Tewksbury, MAN66KSchaetzl Richard · Albuquerque, NMN66LLLetourneau Duane R · Oconto, WIN66ZYHarris Gregory · Huntingdon Valley, PAN6700SAgape Enterprises · Montana City, MTN6701AClarke Christopher E · Cincinnati, OHN6701FHale James W · Darrington, WA
Back to AD 94-05-05 R1