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.

N3137RGriffith Moseley Johnson & Associates Inc · Port Arthur, TXBuilt 1968 · S/N 18258537N3137SManley Robert E · Ferndale, WABuilt 1964 · S/N 18255637N3137UCurson Randy J · Cape Coral, FLBuilt 1962 · S/N 18254537N3137YLopez Juan F Jr · Del Rio, TXBuilt 1962 · S/N 18254137N3138QShepard Donald · Lake Havasu City, AZBuilt 1967 · S/N 18258138N3138R15 Rides LLC · Manteo, NCBuilt 1967 · S/N 18258538N3138TJones Daniel D · Ekron, KYBuilt 1968 · S/N 17700438N3138URegistered aircraftBuilt 1963 · S/N 18254538N3138XBoardman Thomas M · Greenwich, NYBuilt 1966 · S/N 15064538N3139DGuichard Lawrence · Spokane, WABuilt 1955 · S/N 31937N3139QGrubbs Jerry M · Longview, TXS/N 18258139N3139VArrow Trading Inc · Coconut Creek, FLBuilt 1977 · S/N R1722241N313AAAviator Air Operations LLC · Grand Prairie, TXBuilt 2013 · S/N 172S11286N313BLDaggett Keith W · Rockport, MEBuilt 1976 · S/N 17267097N313CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282187N313DQIler Elden · Van Nuys, CAS/N 32533N313GBBurnett Gregory C · Rogersville, MOBuilt 1977 · S/N 21061986N313JWWright George E Jr · Homestead, FLBuilt 1971 · S/N 18260706N313KDOdonnell Daniel Gordon · Plymouth, MABuilt 1975 · S/N 17702353N313MAAbrams David · Holmdel, NJBuilt 1998 · S/N 18280238N313SKJohnson Scott · Blaine, MNBuilt 1973 · S/N 18262630N313YZTextron Aviation Employees' Flying Club Inc · Wichita, KSBuilt 2024 · S/N 172S13179N3140ASzablowski Walter · Riegelsville, PABuilt 1953 · S/N 25784N3140CAthens William A · Missoula, MTBuilt 1954 · S/N 30939N3140FWilliams Thomas G · Richland Center, WIBuilt 1966 · S/N 18257240N3140JSmith Franklin R Sr · York, SCBuilt 1966 · S/N 15065840N3140SLavell Michael J · Blue Mounds, WIS/N 18255640N3140TSuggs Helen T · Jacksonville, FLBuilt 1967 · S/N 17700440N3140XGerasimov Gennady · Jefferson City, MOBuilt 1966 · S/N 15064540N3140YParker Mccrum LLC · Eugene, ORBuilt 1962 · S/N 18254140N3141AHoppe Joel A · Mankato, MNBuilt 1953 · S/N 25785N3141BGoettemoeller Matthew W · Oldtown, IDBuilt 1952 · S/N 25383N3141DNelson Donald W · Aurora, COBuilt 1955 · S/N 31939N3141EPower City Aviation Inc · Hazleton, PABuilt 1978 · S/N 17271449N3141FDoerr John · Sandy, ORBuilt 1966 · S/N 18257241N3141RIncze Bela · Morgan Hill, CABuilt 1967 · S/N 18258541N3141SValley Excavation And Grading Inc · Chatsworth, CABuilt 1964 · S/N 18255641N3141TN3141t LLC · Saint Johns, MIBuilt 1967 · S/N 17700441N3141UMo2 Investing LLC · Springfield, MOS/N 18254541N3141VRenner Thomas J · Williston, NDS/N 15076399N3141XMalo Lee M · Peabody, MABuilt 1966 · S/N 15064541N3142AKrueger Robert C · Glenburn, MEBuilt 1953 · S/N 25786N3142CItm Electronics Inc · Greenleaf, IDBuilt 1954 · S/N 30941N3142QRogers James · Summerfield, FLBuilt 1967 · S/N 18258142N3142SB&G Aircraft LLC · Greensboro, GABuilt 1964 · S/N 18255642N3142TTri State Airmotive LLC · Berryville, ARS/N 17700442N3142YOdom Aviation Inc · Cabot, ARS/N 18254142N3143ASkyline Holdings LLC · Big Lake, AKBuilt 1953 · S/N 25787N3143QJlm Management LLC · Clarion, PABuilt 1967 · S/N 18258143N3143RNelson John J · Salmon, IDBuilt 1967 · S/N 18258543
Back to AD 79-10-14 R1