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.
N9723HFlying Tigers Flight School LLC · Houston, TXN9723TLuinstra Lee Vernon · Benton, KSN9723XThornton James P · Amesbury, MAN97240N97240 LLC · Amherst, MAN97246Duggins Robert W · Van Nuys, CAN97257Moser Keith W · Huntington, INN9725GMathis Isaac Thomas · Fletcher, NCN9725QWings Over Texas Holdings LLC · Denton, TXN9725RLongitude 150 LLC · Anchorage, AKN9725TAnderas Per R · Green Bay, WIN9725VAnderson Aerial Spraying Service Inc · Canby, MNN9725XNewling Galen J · Bremerton, WAN97266East Hill Flying Club · Ithaca, NYN97269J&L Aviation LLC · Malta, NYN9726GIrc Holdings Ltd · Allentown, PAN9726TBuettner Casey R · Kearney, NEN9727ACaughlin David Drew · Boise, IDN9727GInternational Air Services Inc Trustee · Carson City, NVN9727TRogers Bob · Mountain Green, UTN9727VDills John H · Ione, WAN97281Wackerli Steve B · Idaho Falls, IDFirst renewal noticeN97282Jav Air Services LLC · Anchorage, AKN97288Bolle Aviation LLC · Clare, MIN9728ADailey Brian A · Strongsville, OHN9728BLowery Janell D · Anchorage, AKN9728MGrant Aviation Inc · Anchorage, AKN9728TBanks Trevor A · Thomaston, GAN97295J-Air LLC · Guthrie, OKN97298Roberts And Connell Llp · San Luis Obispo, CAN9729ABaker Benjamin D · Catasauqua, PAN9729BAnderson Benjamin T · Havre De Grace, MDN9729GBurch Gerald T · Lake Charles, LAN9729TGibbs David F · Greenville, NCN972BBBig Red Buffalo LLC · Hagerman, IDN972DPCrosswind Aviation Of Oklahoma LLC · Stillwater, OKN972FCBlackhawk Holding Corp · Wilmington, DEN972FGRidgeline Assets LLC · Wilmington, DEN972GJPolk County Sheriffs Office · Winter Haven, FLN972KCMustang Sally Aviation LLC · Camden, SCN972LLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN972MAAir Repair Inc · Easton, MDN972NCIal Corp · Lewes, DEN972PMNp Aviation Inc · Naguabo, PRN972TAConfluence Systems Consulting · San Jose, CAN972THUtah State University · Logan, UTN972WWChapel Hill Flying Club Inc DBA · Sanford, NCN97300Jaeger Kurt · Bermuda Dunes, CAN97309Afana Lawrence L Jr · Phoenix, AZN9730FN9730f LLC · Boynton Beach, FLN9730GMcginty Flying Service LLC · Jones, LA
Back to AD 79-10-14 R1