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.
N5147KCline Aircraft LLC · Mena, ARN5147NMace Robert C Jr · Gold Canyon, AZN5147RKirkland Kerry G · Spring, TXN5147UCox Coleman Haynie · Honea Path, SCN5148ATurner Edward J III · Mokena, ILN5148DNick Peak Flying LLC · Mccall, IDN5148EQuandary Consulting Group LLC · Greenwood Village, CON5148FBonura Rocco F Jr · Perkinston, MSN5148HMalad Aviation LLC · Bliss, IDN5148JTc Cavu Club LLC · Traverse City, MIN5148KHetteen David D · Camano Island, WAN5148VAyres Aviation LLC · Santa Monica, CAN51495Wallace State Community College · Hanceville, ALN5149EAce Of Spades Aviation LLC · Las Vegas, NVN5149R5149r LLC · Manhattan, MTN514DPPitts Donald W · Sand Springs, OKN514ERTextron Aviation Inc · Wichita, KSN514FCState Of Alabama · Montgomery, ALN514GCCristan Gene V · Lake Mary, FLN514HPState Of Ohio / Department Of Public Safety · Columbus, OHN514KKSchaperkotter Harold M Jr · Anchorage, AKN514MDPerez Pedro J · Mayaguez, PRN514MRDmc Holdings LLC · Bullard, TXN514MTTrede 2020 C172 LLC · Aurora, ORN514NDAerosim Academy Inc · Sanford, FLN514NYJones Christopher S · Twin Falls, IDN514RBOsprey Holding Company LLC · Foley, ALN514TPactolus Investments LLC · Blounts Creek, NCN514TCChildress Anthony H · Frisco, TXN514TDDay William B · Conroe, TXN5150DTap Solutions Inc · San Diego, CAN5150UMolina Monreal Angel Humberto · Sahuarita, AZN51515Wolfe Douglas S · Yucaipa, CAN5151EBlhh · Dixon, CAN5151QNotsa LLC · Morrison, CON5151RLuszczek Christopher L · Berkshire, NYN51526My Way Aviation LLC · Weston, FLN5152ASaunders George A Jr · Powhatan, VAN5152QB & L Property Holdings LLC · Brush Prairie, WAN5152RAero Marine LLC · Denver, NCN5153DFree Fall Gulf LLC · La Grange, TXN5154AA&J Air Sales Inc · San Antonio, TXN5154DCivil Air Patrol Inc · Maxwell Afb, ALN5154FGilstrap William D · Catoosa, OKN5154QDemio Douglas · Westbrook, CTN5154RKakkar Sunit · Buena Park, CAN5155DPritt Joseph H · Wasilla, AKN5155JCisco Aero LLC · Cisco, TXN5155KSuno LLC · Calhan, CON5155UFlying Unicorn LLC · Aurora, IL
Back to AD 79-10-14 R1