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.
N8729UEpmeier Bruce E · Newburgh, INN872EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN872FALewis University · Romeoville, ILN872FCBlackhawk Holding Corp · Wilmington, DEN872FSTfs Air LLC · Loveland, CON872NCMt Vernon Airport Authority · Mount Vernon, ILN872SPChristiansen Aviation LLC · Wilmington, DEN8730SDederer Laura · Valencia, PAN8730THardin Mark A · Dalton, GAN8730UKachalsky Alan N · Rye, NYN8730ZKalderen Bjorn O · South Orange, NJN8731GCard James D · Mc Cool, MSN8731QHinlein Erich S · Pelham, MAN8731SLawrenz Richard A · Mcpherson, KSN8731TSkol Alaska LLC · Soldotna, AKN8731USemet Marva S · Seattle, WAN8731XKabat Jules M · Las Vegas, NVN8732GPerkins Robert A · New Richmond, WIN8732UHumke John D · Eufaula, OKN8732XHangar 2 Air LLC · Fort Collins, CON8732ZZiprik Russell L · Ball Ground, GAN8733XLaw Offices Of Brent M Ferrel LLC · Albuquerque, NMN8733ZTerway William · Wilsonville, ORN8734TSkimt Aviation LLC · Teaneck, NJN8734UGrow Aviation LLC · Aurora, NEN8734ZHardin Matthew W · Rutherford, CAN8735UJkh Aviation LLC · Cumming, GAN8735ZMcgarity Justin D · Paragould, ARN8736BCampbell Jack G · Spring Valley, WIN8736GSantana Amaury · Winter Haven, FLN8736QCourtney Aviation LLC · Columbia, CAN8736UC & M Aviation Holdings LLC · Brockport, NYN8736XBoggio Richard E · Bradenville, PAN8737BFranklin Rodney S · Burns, ORN8737TSchmitt Gary W · Highlands, NCN8737UMiss Lou Flight LLC · Vidalia, LAN8738URhk Of Kansas · Jefferson City, MON8739GKlott William D · Morris, ILN8739TScranton Brian J · Ridgway, CON8739UAndrews Willard R · Windham, MEN873CPCivil Air Patrol · Maxwell Afb, ALN873EFFlorida Flight Training Center · Venice, FLN873MBKumar Ravin · Carson, CAN873TWN873tw LLC · Hurricane, WVN8740BOltrogge Construction Inc · Absarokee, MTN8740QHampton Harvey E · Simms, MTN8740SBucks Flight Academy LLC · Cashion, OKN8740XUnwrapped LLC · Dover, DEN8741BPhoenix Air Inc · Orland Park, ILN8741GDahlberg James C · Ogilvie, MN
Back to AD 79-10-14 R1