OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N20AXHehmann Richard J · Belleville, ILS/N 177RG1160N20BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13216N20BRYork Stanley A · Leetonia, OHBuilt 1955 · S/N 31563N20CNuxoll Randy G · Eagle, IDS/N P3370145N20CFFried Stephen · Plymouth, MAS/N 26217N20CHRegistered aircraftBuilt 1974 · S/N 18263453N20CUCosta Flying Service Inc · Painted Post, NYBuilt 1980 · S/N 172RG0323N20DEEbright Sean E · Hasty, COS/N 51334N20DKFlight Surgeon LLC · Fayetteville, ARBuilt 1976 · S/N 17266836N20EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2020 · S/N 172S12513N20FCLge Flying Club Inc · Marietta, GABuilt 1970 · S/N 18260314N20HBMontana Sky Aircraft LLC · Kalispell, MTS/N 18262945N20HLCs&P Rocky Mountain Inc · Cypress, TXS/N 21061877N20HTRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1969 · S/N 17258306N20JSOyaski Michael F · Ebensburg, PABuilt 1975 · S/N 18263751N20KHN20kh LLC · Clewiston, FLBuilt 2021 · S/N 18283153N20KJOxford Flying Club Inc · Oxford, CTBuilt 1998 · S/N 18280143N20MUOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271496N20MVElizabeth City State University · Elizabeth City, NCBuilt 2018 · S/N 172S12143N20RHStoltzfus John F Jr · Strasburg, PAS/N 172-68331N20RSStendal Russell M · Hollywood, FLBuilt 1970 · S/N 18501826N20SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11623N20WGBingham James H · Dillingham, AKS/N 33734N20WMMcdonald John P · Kennewick, WAFirst renewal noticeBuilt 1973 · S/N 17261658N21000Yunger John C · Newton, WIBuilt 1972 · S/N 18261346N21001Global Acquisitions Ltd · Davenport, IAS/N 18261347N21004M & J Aviation LLC · Clarkston, MIBuilt 1972 · S/N 18261349N21006Lerma Gilbert L Sr · Salome, AZBuilt 1972 · S/N 18261351N21009Law Jonathan · Davis, CABuilt 1972 · S/N 18261354N2100FDurocher David T · Fernley, NVBuilt 1965 · S/N U206-0301N2100GTpa Skylane LLC · Asheville, NCBuilt 1958 · S/N 51400N2100RAbresch Craig G · Idaho Falls, IDBuilt 1964 · S/N 18255300N2100SBietsch Aviation LLC · Dumfries, VABuilt 2004 · S/N 172S9589N2100ZGreenwood Stephen · Salt Lake City, UTBuilt 1962 · S/N 18051200N21010Mikiewicz Joseph · West Pittston, PABuilt 1972 · S/N 18261355N21013Thompson Jack M Jr · Ithaca, NYBuilt 1972 · S/N 18261357N21014C & G Aviation LLC · Hollandale, MSBuilt 1972 · S/N 18261358N21015Renfro Michael W · Bethel, AKBuilt 1974 · S/N 17263888N21017Eastern Idaho Flying Club LLC · Idaho Falls, IDBuilt 1972 · S/N 18261361N21019Svetfur Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9595N2101EV1 Aviation LLC · Englewood, COBuilt 1978 · S/N 17271155N2101XScofield Bruce W · Batavia, NYBuilt 1972 · S/N 17701785N21020Monteiro Armando D · Stratford, CTBuilt 1972 · S/N 18261364N21022Ameriflyers Of Texas Inc · Addison, TXBuilt 2004 · S/N 172S9660N21024Horlick Harlan C · Crossville, TNBuilt 1972 · S/N 18261366N21028Snflk Leasing LLC · Andrews, TXBuilt 1972 · S/N 18261367N2102EBrooks Terry A · Shelby, NCBuilt 1978 · S/N 17271156N2102FOlson Tim O · Saint Onge, SDBuilt 1964 · S/N U206-0302N2102GPool Lori A · Cody, WYBuilt 1958 · S/N 51402N2102PZima Aviation LLC · Huntington Beach, CABuilt 2004 · S/N 172S9594
Back to AD 79-10-14 R1