OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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.

N63990Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1987 · S/N 0664N6399FRunyan Roger L · Carlton, PAS/N 298RN6399NMcguire Zach T · Jasper, MOBuilt 1967 · S/N 171N6399VBrim Janie J · Auburn, WAS/N 172RG0661N639GSKatzen Edmund · Westhampton, NYBuilt 1991 · S/N 10041N639MARegistration Pending · Santa Cruz, CARegistration pendingBuilt 1964 · S/N 2893N639MRBean Timothy S · Myrtle Beach, SCBuilt 1975 · S/N 28-7515293N639SAAtkins Kelly · Helena, MTBuilt 2005 · S/N S-0002N639TBMurphy Craig D · Boise, IDBuilt 1991 · S/N 938N63ACurry Vertis Michael · Crockett, TXBuilt 1990 · S/N M-II-784N63AKWinchell Lawrence R III · Salem, NJS/N 467-2005N63AMSierra Yankee Victor LLC · Austin, TXBuilt 1980 · S/N 17273981N63BASullivan Richard P · Star, IDBuilt 1963 · S/N 28-1494N63CLThomas Matthew L · Lakeland, FLBuilt 2000 · S/N 20887N63CVClark Terry L · Bartlesville, OKBuilt 1979 · S/N 386-79N63DABass Lake Aviation LLC · Webster, WIBuilt 1998 · S/N 1238-98N63DGMiller Colette L · Sequim, WAS/N 637N63DMDurbin Hal E · Findlay, OHBuilt 1981 · S/N DM2N63EZWorley Dan L · Heber Springs, ARS/N 1109N63FEFour Macs Logistics LLC · Houlka, MSBuilt 1992 · S/N 1225N63FKHawley Robert W · Fort Worth, TXBuilt 1962 · S/N 28-757N63GOneil Liam Trustee · Vashon, WABuilt 1972 · S/N 17260616N63GKRawareo LLC · Warsaw, MOS/N 28-20781N63GSAerial Surveys Inc · Dover, DEBuilt 2002 · S/N 5218N63HYTailwheel Pilots LLC · Lacon, ILBuilt 2001 · S/N 2173N63JDD'Angelo Joseph P · Callicoon Center, NYBuilt 1979 · S/N 17272940N63JWRegistered aircraftBuilt 1977 · S/N 18-7709139N63MMNzere Michael · Crowley, TXBuilt 1963 · S/N 2569N63MSSire Daniel T · Wausau, WIBuilt 2005 · S/N 90768N63MTGriffith Gary L · Palestine, TXBuilt 1962 · S/N M-97N63PLBoeing Employees Flying Club St Louis Inc · Saint Louis, MOBuilt 1977 · S/N 28-7816263N63RH4-D Aviation Consulting LLC · Wilmington, DES/N 60494N63SASky View Aviation LLC · Lenoir, NCBuilt 1973 · S/N 17261610N63SMMoore George L · Spring Hill, KSBuilt 1986 · S/N 63N63TXKilly James · Littleton, COBuilt 1991 · S/N 20360N63WALariscey Adam · Lyons, GABuilt 2002 · S/N 001N63WFThompson Kevin J · Three Rivers, CAS/N 1136N63WMSmith Russell M · Bokeelia, FLBuilt 1996 · S/N 114N63WTRodencal Richard · Wisconsin Rapids, WIBuilt 1998 · S/N 404-98N64001Alpha One Aviation LLC · Corona, NYBuilt 1975 · S/N 17264949N64007Baugh Tommye R · Star City, ARBuilt 1975 · S/N 17264955N6400UAudetat Thomas Jr · Marana, AZBuilt 1962 · S/N 2147N6400VFearon Kenneth M · Sidney, OHBuilt 1980 · S/N 172RG0662N6400WRegistration Pending · Los Osos, CARegistration pendingBuilt 1964 · S/N 28-20468N64014Maynor Robert B · Mansfield, LABuilt 1975 · S/N 17264961N64016Ponderosa Aviators LLC · Baker, MTBuilt 1975 · S/N 17264963N64017Pilots Today Inc · Berlin, MDBuilt 1975 · S/N 17264964N6401JMccarthy J Patrick · Pleasanton, CABuilt 1968 · S/N 28-4817N6401QHunter Donald J · Scottsdale, AZBuilt 1967 · S/N 670141N6401RNorthern Prairie Sky LLC · Erskine, MNBuilt 1966 · S/N 28-21579
Back to AD 79-10-03 R2