AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N6684TButzen Steve B · Sheboygan, WIN6685XTaliaferro John P · Birmingham, ALN6686NClarity Aviation LLC · Anchorage, AKN6687EDriggers David J · Anchor Point, AKN6687FBlakesley Eric R · Canandaigua, NYN6687SSale Reported · Houston, AKSale reportedN6687XReed Ted R · San Angelo, TXN66888Registered aircraftAssigned (import), pending cancellationN6688APouncey Robert · Proctor, ARN6688HSamaritans Purse · Boone, NCN6688NLedson Steven Noble · Sonoma, CAN6688TSelfridge Dennis A · Dighton, KSN6689AMaley Christopher L · Otsego, MIN6689EHeizler Mark W · Oswego, ILN6689FMills Nicolas A · Greenwood, NYN6689SSimpson Dwight D · Phillips, WIN6689TFlying Restorations LLC · Holts Summit, MON6689XBravo Echo Echo LLC · Millersview, TXN668CSTom Wood Aviation · Fishers, INN668DB686 Aviation LLC · Lakewood, CON668EREmbry-Riddle Aeronautical University Inc · Prescott, AZN6690MWatson Joseph F · Colorado Springs, CON6690SSeniram Air Inc · Wilmington, DEN6690TAviation Connection LLC · Lake Worth, FLN6690XWinston Marine LLC · Bellingham, WAN6692EMarshall Jerry J Sr · Parker, AZN6692GHopkins Marissa A · Cameron, MTN6692MEagle Forestry Services Inc · Monticello, ARN6692SNoltensmeyer Kurt Jon · Greenbank, WAN6693HSwithenbank Leonard Co-Trustee · Fort Bragg, CAN6694ADenslow Carl W · Barto, PAN6694EThunderbird Aviation LLC · Littleton, CON6694FWanagel Walter · Lisbon, CTN6694GChatas John W · Ann Arbor, MIN6694NGear Down LLC · Dalhart, TXN6695AStewart Guy C · Stevens Point, WIFirst renewal noticeN6695MRegistration Pending · Sheridan, WYRegistration pendingN6695SOlsen Raymond E · Washington, UTN6695TSischka Nicholas A · Haddon Heights, NJN66964Tyler Daniel Jr · Durango, CON6696FYoung Deborah C · Lopez Island, WAN6696SJohnson Jay E · Murray, IAN6696XTesch Timm A · Spring, TXN66978Tupper Daniel A · Groveland, CAN6697AHart David L · Oxnard, CAN6697EMartin Jonathan · Trumann, ARN6697FLogan Thomas H · Canfield, OHN6697GPaul William A · Windfall, INN66987De Brouwer Isabelle Mc · Alpine, TXN6698TJeplawy Elizabeth A · Glenwood Springs, CO
Back to AD 79-10-14 R1