OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N3733LHillstrom Rudolph A · Oakville, WABuilt 1965 · S/N 17253902N3733RCouick Donald Michael · Monroe, NCBuilt 1966 · S/N 17255533N3733SBrn Technical Inc · Boca Raton, FLBuilt 1963 · S/N 17250933N3733VToccoa Aviation · Toccoa, GABuilt 1975 · S/N 15076605N3733YHolliday Ivan Scott · Poplarville, MSBuilt 1963 · S/N 21058233N3734DVessey William M · Yuma, AZBuilt 1957 · S/N 34434N3734JTrue Course LLC · Honolulu, HIBuilt 1966 · S/N 15065034N3734LBertrand Todd A · Anchorage, AKBuilt 1965 · S/N 17253903N3734VBurrell Dennis E · Parma, IDS/N 15076606N3735FEb Flight Training LLC · Daytona Beach, FLBuilt 1966 · S/N 17255230N3735JPetersen Kenton D · Jefferson, SDBuilt 1966 · S/N 15065035N3735SBeucler Brian G · Sandown, NHFirst renewal noticeBuilt 1963 · S/N 17250935N3736UDelong Don R · Wheeler, MIBuilt 1963 · S/N 18255136N3737VClarke Adrian N · Aledo, TXBuilt 1975 · S/N 15076607N3738DHall Chris S · Garden City, MOBuilt 1959 · S/N 34438N3738LTran Tuan M · Canton, MIBuilt 1965 · S/N 17253907N3738YAirborne Solutions Group LLC · Dayton, OHBuilt 1963 · S/N 21058238N3739DBodie Aviation Ltd · Laporte, COS/N 34439N3739FSchlueter Helmuth K · San Tan Valley, AZS/N 17255234N3739LMattson David G · Lake Park, MNBuilt 1965 · S/N 17253908N3739RRusak Robert J · Paris, TXBuilt 1966 · S/N 17255539N3739UYown Inc · Ethridge, MTBuilt 1963 · S/N 18255139N3739YCessna 210 LLC · Ogden, UTBuilt 1963 · S/N 21058239N373AZFausel Cheryl A · Cape Coral, FLS/N 337M0079N373CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281986N373HShumate Johnny E · Spring, TXBuilt 1974 · S/N 21060190N373KVCrystalinas Johnathan · Rancho Cordova, CABuilt 1966 · S/N 15064401N373PJRock Creek Corp · Henderson, NVBuilt 1978 · S/N 21062887N373SAValiair Lc Trustee · Casper, WYBuilt 2019 · S/N 18283087N3740FLavalley Asset Management · Potsdam, NYBuilt 1966 · S/N 17255235N3740JHersom Jeffrey T · Helena, MTBuilt 1966 · S/N 15065040N3740RRhodes Samuel R · Bonne Terre, MOBuilt 1967 · S/N 17255540N3740SGarnsey Zene P · Schuylerville, NYBuilt 1963 · S/N 17250940N3740UFlight Club 502 Inc · Louisville, KYBuilt 1963 · S/N 18255140N3740YOmg Air LLC · Okeechobee, FLBuilt 1964 · S/N 21058240N3741DTrouwborst Keith J · Lander, WYBuilt 1957 · S/N 34441N3741FMclanahan John P · Culpeper, VAS/N 17255236N3741JSharp Ruth · Clarksville, TNBuilt 1966 · S/N 15065041N3741RAbecca Corp · Jackson, MIBuilt 1966 · S/N 17255541N3742JLow Cost Flying LLC · Chandler, AZBuilt 1966 · S/N 15065042N3742SHand Jerry A · Nacogdoches, TXBuilt 1963 · S/N 17250942N3743DLanzisera Francesco · Questa, NMBuilt 1957 · S/N 34443N3743FRohde William B · Homer, NEFirst renewal noticeBuilt 1966 · S/N 17255238N3743GMahler Richard Keith · Haines, AKS/N 26301N3743LAero Flight Two LLC · Peoria, AZS/N 17253912N3743UHughes Kathryn G · Council, IDBuilt 1963 · S/N 18255143N3743YCooper Jess D · Spanaway, WAS/N 21058243N3744CVand Flyve Klub Inc · Thief River Falls, MNBuilt 1957 · S/N 32792N3744DMorcom Ronald W Jr · Stanwood, WABuilt 1957 · S/N 34444N3744LAir Jeffery LLC · Aledo, TXBuilt 1965 · S/N 17253913
Back to AD 79-10-14 R1