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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N413EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12640 N413ESAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280218 N413LBOficinas De Carolina Inc · San Juan, PRBuilt 1981 · S/N 18504200 N413MASterling Flight Training LLC · Jacksonville, FLBuilt 1976 · S/N 17267164 N413MFRegistered aircraftBuilt 2015 · S/N 18282412 N413RDDos Amigos Air Service LLC · Carrizo Springs, TXBuilt 2004 · S/N 18281464 N413TAInfinite Runway LLC · Union City, CABuilt 1981 · S/N 18267922 N4140VDirigo Aerospace Solutions LLC · Sumner, MEBuilt 1948 · S/N 18472 N4141LPeder Richard A · Sequim, WABuilt 1966 · S/N 17254210 N4142LSegura Michelle Marie · Dallas, TXBuilt 1966 · S/N 17254211 N4143FSteier Tim A · Salome, AZBuilt 1958 · S/N 46043 N4143VRegistered aircraftBuilt 1948 · S/N 18475 N4144FKoch Gerald P · Mount Vernon, SDBuilt 1958 · S/N 46044 N4144URinaudo James J · Gulf Shores, ALBuilt 1963 · S/N 15060144 N4144VLadage Terry L · Champaign, ILBuilt 1948 · S/N 18622 N4145Dittlinger Bret W · Anchorage, AKBuilt 1957 · S/N 32840 N4145USt Peter John P · Hicksville, OHBuilt 1963 · S/N 15060145 N4146FGompert Andrew B · Burwell, NEBuilt 1958 · S/N 46046 N4146UKobza Leslie J · White Bear Lake, MNBuilt 1963 · S/N 15060146 N4147FSwan Steve · Jackson, WYBuilt 1958 · S/N 46047 N4147UEast Tennessee Pilots Club Inc · Knoxville, TNBuilt 1963 · S/N 15060147 N4148FBorders Jimmie L · Tompkinsville, KYBuilt 1958 · S/N 46048 N4149FCarruth Peter J · Benson, MNS/N 46049 N4149LRegistration Pending · Bryan, OHRegistration pendingS/N 17254218 N4149UMinard Nicholas R · Chandler, AZS/N 15060149 N4149VBush Brett C · Cody, WYBuilt 1948 · S/N 18481 N414EDDavis Gabriel L · Dillingham, AKBuilt 1971 · S/N 18501838 N414ERRegistration Pending · Wilmington, DERegistration pendingBuilt 2017 · S/N 172S12026 N414KFDilworth Andrew R DBA · Los Gatos, CABuilt 1980 · S/N 180-53147 N414MEEight Ball Flying Club Inc · Van Nuys, CABuilt 2000 · S/N 18280865 N414PKTakeoff Properties LLC · Belmont, NCBuilt 2023 · S/N 18283243 N414SCPaul Sachitano LLC · Beaumont, TXBuilt 1978 · S/N 18266352 N414TBTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2026 · S/N 172S13494 N414WDDonaldson Ted M · Thatcher, AZBuilt 1956 · S/N 33654 N4150FRegistration Pending · Clinton Township, MIRegistration pendingS/N 46050 N4150LBlankenship Daniel S · Paso Robles, CABuilt 1966 · S/N 17254219 N4150ULong Sarah Louise · Fort Wayne, INS/N 15060150 N4150VDorsey Christopher · Round Rock, TXBuilt 1948 · S/N 18482 N4151LPardun Phillip R · Mason City, IABuilt 1966 · S/N 17254220 N4151UHuskey Ryan J · Edmond, OKS/N 15060151 N4151VRisner Rick · Vernon, TXS/N 18483 N4152FGaertner Kim L · Oconto, WIBuilt 1958 · S/N 46052 N4152LLambert Robert · Paoli, INBuilt 1966 · S/N 17254221 N4152VBrewer Samuel T · Wasilla, AKS/N 18484 N4153FChaffee Craig O · Le Raysville, PABuilt 1958 · S/N 46053 N4153VBenoit Bob W · Hot Springs, ARBuilt 1963 · S/N 18485 N4154DBriggs John M · Vancouver, WABuilt 1951 · S/N 20037 N4154VWindsock Capital LLC · Bertram, TXS/N 18486 N4154YMehling Robert C · Hardin, MTS/N 185-0354 N4155VBeavert Curt E · Murfreesboro, ARBuilt 1948 · S/N 18487

Back to AD 79-10-14 R1