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.

N9550BMccall Freddie W · Brewton, ALBuilt 1981 · S/N 172RG0872N9550GCopper Skies Aviation LLC · Mesa, AZBuilt 1998 · S/N 17280516N9550QDecatur Aero Club Inc · Decatur, ILBuilt 1998 · S/N 17280517N9550SBald Eagle Enterprises Inc · Nashville, TNBuilt 1999 · S/N 17280758N9551BLopes Gaston A · Dallas, TXS/N 172RG0873N9551WBcbc Aero Services LLC · Dover, DEBuilt 1998 · S/N 18280207N95521Martin Aviation LLC · Kalispell, MTBuilt 1978 · S/N 18266566N95528Welch Clare A · Longboat Key, FLBuilt 1978 · S/N 18266567N9552AAmeriflyers Of Texas Inc · Addison, TXBuilt 1998 · S/N 17280531N9552GJesse Shipman Farms LLC · Honey Grove, TXBuilt 1974 · S/N 18801529TN9552HZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1975 · S/N 17266223N9552RCauv LLC · Cincinnati, OHBuilt 1998 · S/N 18280167N9552VRico Aviation Services Inc · Miami, FLBuilt 1974 · S/N 17264354N9553ATitusville Aero Club Inc · Titusville, PABuilt 1998 · S/N 17280376N9553SHunters Adventures LLC · Kennesaw, GABuilt 1998 · S/N 18280254N9553XMccarthy Sean P · Jacksonville Beach, FLBuilt 1962 · S/N 21057853N95540Gracejet Aviation LLC · Brownsboro, TXS/N 18266571N95541Pershing Air LLC · Sheridan, WYBuilt 1978 · S/N 18266572N95544Keller Lucas J · Vale, ORBuilt 1978 · S/N 18266574N9554ABagley James L · Pampa, TXBuilt 1950 · S/N 19390N9554GMorse Donald · Priest Lake, IDBuilt 1972 · S/N U20601754N9554VCavu LLC · Fort Collins, COBuilt 1974 · S/N 17264356N9555GMccormick Eugene C · Tyler, ALBuilt 1974 · S/N 18801531N9555HWilkinson William · Anchorage, AKBuilt 1975 · S/N 17266226N9555XWalker Scott · Mammoth Lakes, CABuilt 1974 · S/N 18263495N9556JS & D Spraying Service Inc · Panhandle, TXBuilt 1981 · S/N 18803821N9556VMiles James D · Memphis, TNBuilt 1974 · S/N 17264358N9556ZIsland Aircraft LLC · Anchorage, AKBuilt 1918 · S/N U20606543N9557BGibson Robert B · Los Alamos, NMBuilt 1981 · S/N 172RG0879N9557PHendrix Steven · Bakersfield, CAS/N 18280294N9557VSkyhawk 57v Inc · Pittsburgh, PABuilt 1974 · S/N 17264359N9557XCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 18268553N9558BGrap Jeffrey G · Statham, GABuilt 1957 · S/N 32855N9558TWatson Stephen C · Flemingsburg, KYBuilt 1960 · S/N 57358N9558XWagner Larry D · Raleigh, NCBuilt 1986 · S/N 18268554N9559AGrace'S Wings LLC · Crystal Lake, ILFirst renewal noticeBuilt 1949 · S/N 19120N9559DChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280488N9559SElizabeth Dloda LLC · Hilton Head Island, SCBuilt 1998 · S/N 17280490N9559VOcm Aviation LLC · Buckeye, AZBuilt 1998 · S/N 17280491N9559XSkid Kids Aircraft Holding LLC · Grand Junction, COBuilt 1986 · S/N 18268555N955ACNaples Air Center Inc · Naples, FLBuilt 2001 · S/N 172S8984N955BCWilson Douglas S · Imperial, NES/N 18263036N955CCN955cc LLC · Estero, FLBuilt 1969 · S/N 17258826N955CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12157N955JAAero Equities LLC · Ventura, CABuilt 2007 · S/N 172S10501N955LCSewell Michael D DBA · Russellville, ALBuilt 1974 · S/N 17264572N955LSSomd Seaplanes LLC · Lexington Park, MDBuilt 1973 · S/N 18502259N955MSSanz Mark L · Missoula, MTBuilt 1974 · S/N 18262965N955PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264573N955RSDuck Troy · Kannapolis, NCS/N 17250144
Back to AD 79-10-14 R1