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.

N9085MLee Aviation Group LLC · Fort Myers, FLBuilt 1976 · S/N 18264670N9085XCessna 182 LLC · Missoula, MTS/N 18253485N9086ATaylor Scott G · Draper, UTBuilt 1949 · S/N 18845N9086GWilcox Leo Morgan · Winnie, TXBuilt 1971 · S/N 18260626N9086ZCy Air LLC · Springfield, MOBuilt 2011 · S/N 18282281N9087GHigh Planes LLC · Carter, MTBuilt 1971 · S/N 18260627N9087TGuminsky Michael · Toano, VAFirst renewal noticeBuilt 1960 · S/N 52987N9087XLane James T · Theodosia, MOBuilt 1961 · S/N 18253487N9088ACox-Kuss Sarah Ann · Colorado City, TXBuilt 1949 · S/N 18847N9088XFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVBuilt 1961 · S/N 18253488N9089HDavis Joseph S · Andalusia, ALBuilt 1975 · S/N 17265936N9089XSebec Aviation Services LLC · Willimantic, MES/N 18253489N908CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8331N908ENEl Aviation LLC · Alpena, MIBuilt 2000 · S/N 20608105N908EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12970N908FGRidgeline Assets LLC · Wilmington, DEBuilt 2021 · S/N 172S12724N908HPNiessner Steven A · Golden, COBuilt 1981 · S/N 18267881N908MCL2 Leasing LLC · Orem, UTS/N 18281900N908SCGomez Ryan Rene · Fort Worth, TXBuilt 1976 · S/N 177RG0943N9091HCampbell Raymond · Box Elder, SDBuilt 1975 · S/N 17265937N9091MFrisbee Dennis R · Denton, TXBuilt 1976 · S/N 18264672N9091TBeachy Daniel W · Council, IDBuilt 1960 · S/N 52991N9092HWinemiller Stevie Dale · Swifton, ARBuilt 1975 · S/N 17265938N9092XWharton Joel E · Millsboro, DEBuilt 1961 · S/N 18253492N9093GThomas Kent · Wilsonville, ORBuilt 1971 · S/N 18260633N9094GRicks Thomas C · San Carlos, CABuilt 1971 · S/N 18260634N9094RPetecraft Aviation Services Inc · Plains, GABuilt 1975 · S/N 18802110TN90951Simard Maurice E · Windham, CTBuilt 1956 · S/N 28984N9095MSchramm Dale · Toledo, WABuilt 1971 · S/N 18052195N9095XTaylor William E Trustee · Waynesville, MOBuilt 1961 · S/N 18253495N9096HCallaway Mary Ann · Homedale, IDBuilt 1975 · S/N 17265941N9096MRedd Charles H Jr · Wasilla, AKBuilt 1971 · S/N 18052196N9096ZChristianen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 172S11086N9097AWard Daniel Wayne · Boonville, NCS/N 18856N9097GScharping Glenn Alan · Whitelaw, WIBuilt 1971 · S/N 18260637N9097MClark David T · Grand Rapids, MNBuilt 1971 · S/N 18052197N9097XMcmillin Charles R · Lynn, MIBuilt 1961 · S/N 18253497N9098AWestphal Keith H · Mazomanie, WIBuilt 1949 · S/N 18857N9098X98x LLC · Caddo Mills, TXBuilt 1961 · S/N 18253498N9099GRegistration Pending · Edmond, OKRegistration pending, pending cancellationBuilt 1971 · S/N 18260639N9099XSnow Sam L · Las Cruces, NMBuilt 1961 · S/N 18253499N909CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8909N909CQVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281618N909CSBarbers Point Flight School LLC · Kapolei, HIBuilt 2021 · S/N 172S12609N909DBN909db Aviation Services LLC · Colorado Springs, COBuilt 1997 · S/N 17280031N909EDEdwards Aero Club · Edwards Afb, CABuilt 2012 · S/N 172S11155N909EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12973N909GBHead West Lake Operations LLC · Dubois, WYBuilt 1978 · S/N 18503519N909KSKingsky Flight Academy LLC · Lakeland, FLBuilt 2005 · S/N 172S10031N909MRRipp Patrick L · Mineral Point, WIBuilt 1967 · S/N 15066219
Back to AD 79-10-14 R1