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.

N3544WRapid Fleet I LLC · Carmel, INBuilt 2001 · S/N 172S8904N3544YPeters Ben · Seminole, TXBuilt 1962 · S/N 18254444N3544ZSky Chiefs Aviation LLC · Gainesville, FLS/N 172S8999N35450Cole William A · San Francisco, CABuilt 1968 · S/N 17256775N35454Norman Robert Alan · Zanesville, OHBuilt 1968 · S/N 17256778N35456Wing Dock LLC · Miami, OKBuilt 1968 · S/N 17256779N3545DHudson Guy G · Chickaloon, AKS/N 27088N3545JBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 18281023N3545SMaldonado Edward R · Independence, ORBuilt 1963 · S/N 17250745N3545VSoaring Pinions LLC · Rittman, OHBuilt 1975 · S/N 15076541N35461Registered aircraftBuilt 1968 · S/N 17256781N35465Hunkus Kenneth F · San Angelo, TXS/N 17256783N35467Brown Wilson J · Statesville, NCBuilt 1968 · S/N 17256785N35469Oord Joshua · Moses Lake, WABuilt 1968 · S/N 17256786N3546EDussinger Andrew M · Enola, PABuilt 1978 · S/N 17271582N3546FN3546f LLC · Kitty Hawk, NCBuilt 1966 · S/N 18257546N3546HOdonnell John Merritt · Kennebunkport, MEBuilt 2001 · S/N 18281017N3546JFerguson David G · Candler, NCBuilt 1965 · S/N 15061246N3546QRahe John S · Marana, AZS/N 172S8889N3546SJackson Harry Jason · El Centro, CAS/N 17250746N35470Lombardi Michael J · Bloomfield Hills, MIBuilt 1968 · S/N 17256787N35474Massey Shawn A · Satanta, KSBuilt 1968 · S/N 17256789N35477Schmidt Edward J Sr · North Brunswick, NJBuilt 1968 · S/N 17256790N3547FEastern Kentucky University · Richmond, KYS/N 172S8887N3547HCali Air LLC · San Ramon, CAS/N 172S8886N3547LSky Brothers LLC · Boulder, COS/N 172S8884N3547RL & R Flyers LLC · Bradenton, FLS/N 17281066N3547SThhm LLC · Menomonie, WIBuilt 1963 · S/N 17250747N3547UPanhandle Aviation LLC · Thatcher, AZBuilt 1963 · S/N 18254947N3547YS & W Aviation LLC · Saint Peters, MOBuilt 1962 · S/N 18254447N35486Metz Air LLC · Little Rock, ARS/N 17256796N35488Collins Mason G · Gillette, WYS/N 17256797N3548MSpenser Air LLC · Starkville, MSS/N 18281019N3548SSunny Skies Aviators LLC · Vernal, UTS/N 18281018N3548VT-28 LLC · Salem, ORBuilt 2001 · S/N 172S8892N35491L&W Leasing LLC · Smyrna, TNS/N 17281069N35495Whitfill Charles Carlton · Blum, TXBuilt 1976 · S/N 177RG1050N35498Ray Arthur G · Springdale, ARBuilt 1973 · S/N 21059996N3549CTappen Paul W · Delta Junction, AKS/N 26593N3549SSchott Roy W · Derby, KSBuilt 1963 · S/N 17250749N3549UKimble Bryant Shane · Hinton, OKS/N 18254949N3549VSmith Jacques F · Anchorage, AKS/N R1722257N3549YTimuuu Inc · Alden, NYBuilt 1962 · S/N 18254449N354BSStevenson Bill · Sunrise Beach, TXS/N 210-60381N354CPCivil Air Patrol · Montgomery, ALBuilt 2005 · S/N 18281506N354CTCoast Flight Training And Management Inc · San Diego, CABuilt 2009 · S/N 172S10942N354ESN354es LLC · Stuart, FLBuilt 1997 · S/N 17280047N354STelfer William D · Perkasie, PABuilt 1999 · S/N 18280650N354TAChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9354N355Roads Development LLC · Miami, FLS/N P3370239
Back to AD 79-10-14 R1