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.
N6142TMiller Timothy A · Opheim, MTN6142XHurt Ronald L · Smithville, TNN61438Peot James J · Woodinville, WAN6143BRushing Harley J III · Cheraw, SCN6143GSale Reported · Brodhead, WISale reportedN61441Cook Sterling S · Wasilla, AKN6144BRieser Robert · Aurora, ILN6144EBlack Kenneth Cory · Chillicothe, OHN6144GHoke Christopher R · Kernersville, NCN61455Hutcheson David Carl · Santa Rosa Beach, FLN6145ESaylor Willa G · Newburg, PAN6145FAlpha Bravo Aviation LLC · Trophy Club, TXN6145TJones Blake · Selma, ALN6146BMiles From Ordinary LLC · Auburn, WAN6146EDahlberg James C · Ogilvie, MNN6146FHeppner Sebastian · Fishers, INN6146TDanyal David · Lake Stevens, WAN61471N484rf LLC · Jackman, MEN61473U S Department Of Interior · Boise, IDN61474Harper Analeasa Leighan · Clarksville, TNN6147BMock David J · Mesa, AZN6147FHenry Charles C · Portland, TNN6147RBloom James F · Clay City, KYN6147TBooks Clifton B · Harrah, OKN6148EPlant Robert L · Churubusco, INN6148FWorsham Eric S · La Porte, TXN6149EOliphant John R · Houston, TXN6149KTurbine Financial Group LLC · Ogden, UTN6149VFoode Frank J · Cordova, AKN614AZWienholt Robert Jr · Perry Hall, MDN614EREmbry-Riddle Aeronautical University Inc · Prescott, AZN614FAHillsboro Aero Academy LLC · Hillsboro, ORN614LFLunken Flight Training Center LLC · Cincinnati, OHN614VZVision Aircraft LLC · Scottsdale, AZN6150ENeedham George T · Seattle, WAN6150FFranklin Aviation LLC · Paradise, CAN6150GStockton Raymond L · Pearl City, HIN6150KAult Greg · Princeton, INN6150RChristy David L DBA · Meriden, KSN6150THaug Michael A · Spring Lake, MIN61516Zaikof Bay LLC · Jackson, WYN6151BCasey Ross H · Boise, IDN6151KRomano Aviation LLC · Barrington, RIN6151RPath Barney H DBA · Claremont, CAN6151UMccall John A · Grapeland, TXN6151YBulloch Troy P · Cedar City, UTN61522Zipay Michael A · Willow, AKN6152BMohave County Board Of Supervisors · Kingman, AZN6152ESkyranch Knoxville Youth Inc · Knoxville, TNN6152FFisher Wayne G Trustee · Gainesville, FL
Back to AD 79-10-14 R1