OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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-03-R2')
    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-03-R2')
  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.

N9555CVimana LLC · Chandler, AZBuilt 1978 · S/N 28-7816491N9555DGehring Robert A · Rubicon, WIBuilt 1958 · S/N 22-6472N9555HWilkinson William · Anchorage, AKBuilt 1975 · S/N 17266226N9555JPaper Airplane Club LLC · Hillsdale, MIBuilt 1966 · S/N 28-3685N9555LSouth Co Flyers Inc · Cranston, RIBuilt 1974 · S/N AA5-0555N9556DHanderson Ronald J Sr · Sitka, AKBuilt 1958 · S/N 22-6473N9556VMiles James D · Memphis, TNBuilt 1974 · S/N 17264358N9556WMathison John M · Fernley, NVS/N 28-22993N9557BGibson Robert B · Los Alamos, NMBuilt 1981 · S/N 172RG0879N9557KCook Walter T · Centerville, TNBuilt 1976 · S/N 28-7690260N9557LFarrar Curtis L · Pryor, OKBuilt 1974 · S/N AA5-0557N9557VSkyhawk 57v Inc · Pittsburgh, PABuilt 1974 · S/N 17264359N9557WBowles Dan S · Wichita, KSBuilt 1967 · S/N 28-22994N9558DMadison James Edward · Concord, CAS/N 22-6475N9559WRickman Kevin A · Brownville, NYBuilt 1967 · S/N 28-22996N955BJFulfer Richard S · Applegate, CABuilt 2001 · S/N 23192N955CCN955cc LLC · Estero, FLBuilt 1969 · S/N 17258826N955DDRegistration Pending · Fort Wayne, INRegistration pendingBuilt 1977 · S/N 28-7725206N955LCSewell Michael D DBA · Russellville, ALBuilt 1974 · S/N 17264572N955MATaylor Christopher B · Vacaville, CABuilt 1966 · S/N 3384N955PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264573N955SEmge Douglas W · Albertville, ALBuilt 1979 · S/N 287990385N955SKConcho Aviation LLC · Sterling City, TXBuilt 2005 · S/N 3969N955SMCustom Concrete & Building LLC · Pleasantville, TNBuilt 2004 · S/N 21087CN955TMaynard Robert R · Inglewood, CARegistration revokedBuilt 1960 · S/N TD-401N9560JAdams Carl J · Conroe, TXS/N 28-3691N9560VRegistration Pending · Big Spring, TXRegistration pendingBuilt 1974 · S/N 17264362N9561CRak Flight Squad LLC · Bronx, NYBuilt 1978 · S/N 28-7816493N9561DHughey Randal P · Muskegon, MIBuilt 1958 · S/N 22-6478N9561JScarlet Aviation LLC · Jonestown, PAS/N 28-3692N9561LWalter Terrance A · Pinckney, MIBuilt 1974 · S/N AA5-0661N9561MAck & Co LLC · East Helena, MTBuilt 1967 · S/N 670106N9562BCharleston Flying Club LLC · Charleston, SCBuilt 1981 · S/N 172RG0882N9562HL & W Aircraft Investments LLC · Homestead, FLBuilt 1975 · S/N 17266230N9562JPosnett William L III · Lexington Park, MDBuilt 1966 · S/N 28-3697N9562UFoote Peter S · Lockport, NYBuilt 1977 · S/N AA1C0061N9562VWinged Winds LLC · Douglassville, PABuilt 1974 · S/N 17264364N9562WHub City Aviation Academy LLC · Lubbock, TXBuilt 1967 · S/N 28-22999N9563LFite James · Victorville, CABuilt 1974 · S/N AA5-0563N9563PTodd Doug A · De Witt, IAS/N 18-7609155N9563WEastside Development Co Inc · Winfield, KSBuilt 1967 · S/N 28-23000N9564CPowell David K · Edwardsville, ILBuilt 1978 · S/N 28-7890422N9564HLafleur Laurence J · Natick, MABuilt 1975 · S/N 17266232N9564JIrvin Stephanie Michelle · Jacksonville, FLBuilt 1966 · S/N 28-3699N9565JNebeker Kayla Rae · Murrieta, CABuilt 1966 · S/N 28-3700N9566BQualitair LLC · MichelstadtBuilt 1981 · S/N 172RG0885N9566DHerbert Brendan A · Portola, CAS/N 22-6483N9566HGarcia Mario · Yuma, AZBuilt 1975 · S/N 17266233N9566LNorth Sound Aviation · Sedro Woolley, WABuilt 1986 · S/N 17276578N9566VS D Enterprises Ltd · Brookhaven, NYBuilt 1974 · S/N 17264368
Back to AD 79-10-03 R2