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.

N8729UEpmeier Bruce E · Newburgh, INBuilt 1965 · S/N 17252633N872EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13520N872FALewis University · Romeoville, ILBuilt 2002 · S/N 17281109N872FCBlackhawk Holding Corp · Wilmington, DEBuilt 1980 · S/N 17273875N872FSTfs Air LLC · Loveland, COBuilt 2003 · S/N 17281172N872NCMt Vernon Airport Authority · Mount Vernon, ILBuilt 1981 · S/N 17274780N872SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8134N8730SDederer Laura · Valencia, PAS/N 15062030N8730THardin Mark A · Dalton, GABuilt 1960 · S/N 52630N8730UKachalsky Alan N · Rye, NYBuilt 1976 · S/N 15077975N8730ZKalderen Bjorn O · South Orange, NJBuilt 1978 · S/N 177RG1338N8731GCard James D · Mc Cool, MSBuilt 1966 · S/N 15062831N8731QHinlein Erich S · Pelham, MABuilt 1976 · S/N U20603484N8731SLawrenz Richard A · Mcpherson, KSS/N 15062031N8731TSkol Alaska LLC · Soldotna, AKS/N 52631N8731USemet Marva S · Seattle, WABuilt 1976 · S/N 15077976N8731XKabat Jules M · Las Vegas, NVBuilt 1960 · S/N 18253131N8732GPerkins Robert A · New Richmond, WIBuilt 1966 · S/N 15062832N8732UHumke John D · Eufaula, OKS/N 17252636N8732XHangar 2 Air LLC · Fort Collins, COBuilt 1960 · S/N 18253132N8732ZZiprik Russell L · Ball Ground, GABuilt 1968 · S/N P206-0532N8733XLaw Offices Of Brent M Ferrel LLC · Albuquerque, NMBuilt 1961 · S/N 18253133N8733ZTerway William · Wilsonville, ORBuilt 1968 · S/N P206-0533N8734TSkimt Aviation LLC · Teaneck, NJBuilt 1960 · S/N 52634N8734UGrow Aviation LLC · Aurora, NEBuilt 1965 · S/N 17252638N8734ZHardin Matthew W · Rutherford, CABuilt 1968 · S/N P206-0534N8735UJkh Aviation LLC · Cumming, GABuilt 1965 · S/N 17252639N8735ZMcgarity Justin D · Paragould, ARBuilt 1968 · S/N P206-0535N8736BCampbell Jack G · Spring Valley, WIBuilt 1957 · S/N 36436N8736GSantana Amaury · Winter Haven, FLBuilt 1966 · S/N 15062836N8736QCourtney Aviation LLC · Columbia, CABuilt 1976 · S/N U20603489N8736UC & M Aviation Holdings LLC · Brockport, NYBuilt 1965 · S/N 17252640N8736XBoggio Richard E · Bradenville, PABuilt 1961 · S/N 18253136N8737BFranklin Rodney S · Burns, ORBuilt 1957 · S/N 36437N8737TSchmitt Gary W · Highlands, NCBuilt 1960 · S/N 52637N8737UMiss Lou Flight LLC · Vidalia, LABuilt 1965 · S/N 17252641N8738URhk Of Kansas · Jefferson City, MOBuilt 1976 · S/N 15077977N8739GKlott William D · Morris, ILBuilt 1966 · S/N 15062839N8739TScranton Brian J · Ridgway, COBuilt 1960 · S/N 52639N8739UAndrews Willard R · Windham, MEBuilt 1965 · S/N 17252643N873CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281872N873EFFlorida Flight Training Center · Venice, FLBuilt 2006 · S/N 172S10163N873MBKumar Ravin · Carson, CABuilt 2000 · S/N 18280888N873TWN873tw LLC · Hurricane, WVS/N 17273301N8740BOltrogge Construction Inc · Absarokee, MTBuilt 1957 · S/N 36440N8740QHampton Harvey E · Simms, MTS/N U20603493N8740SBucks Flight Academy LLC · Cashion, OKS/N 15062040N8740XUnwrapped LLC · Dover, DES/N 18253140N8741BPhoenix Air Inc · Orland Park, ILBuilt 1957 · S/N 36441N8741GDahlberg James C · Ogilvie, MNS/N 15062841
Back to AD 79-10-14 R1