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.

N9180TMcguire Michael D · Lake Stevens, WABuilt 1996 · S/N 3250N91813Fallbrook Fly Girl LLC · Lakeside, ORBuilt 1973 · S/N 17261515N9181SFhs Aero Co Ltd · Olathe, KSBuilt 1976 · S/N M-1798N91823Perra John James Trustee · Gardnerville, NVBuilt 1973 · S/N 17261516N9182HMouton Charles · Gladewater, TXBuilt 1975 · S/N 17265997N9182JTremblay Christopher A · Albion, MEBuilt 1966 · S/N 28-3250N9182KRoth Howard R · Mott, NDBuilt 1976 · S/N 28-7625169N9182SBig Bend Community College · Moses Lake, WABuilt 1975 · S/N MB-786N9182WMoyer Aviation Inc · Tobyhanna, PABuilt 1989 · S/N 2841130N91834Skylink Xpress Inc · San Bernardino, CABuilt 1989 · S/N 2841141N9183KKoinzan Flying Service Inc · Elgin, NEBuilt 1996 · S/N 110N9183SToole William Barry · Goochland, VABuilt 1976 · S/N M-1802N9184LKindred Champ LLC · Hickson, NDBuilt 1971 · S/N 327-72N9184VCloud Distributing LLC · Austin, TXBuilt 1969 · S/N 690036N91854Sjostedt Brad D · Cordova, AKS/N 357-72N9185HFlyit LLC · Washougal, WABuilt 1975 · S/N 17265999N9185JRatcliff Dale A · Granville, OHBuilt 1966 · S/N 28-3253N9185LKnighten Ammon J · Gakona, AKBuilt 1971 · S/N 324-72N9185SGrushkin Jon S · Mazon, ILBuilt 1976 · S/N M-1799N91862Aire Services LLC · Barrigada, GUBuilt 1973 · S/N 17261519N9186DEckels Daniel R · Centerburg, OHBuilt 1958 · S/N 22-6244N9186KMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7615181N9186LAshby Darrell T · Elko, MNBuilt 1971 · S/N 231-72N9186MBlazer Aviation LLC · Charlotte, NCBuilt 1992 · S/N 10122N9186SHigh Flyin LLC · Canton, MSBuilt 1976 · S/N M-1805N9187LGardner James Jr · El Campo, TXBuilt 1971 · S/N 328-72N9187MPhillips Tim · Blair, OKBuilt 2001 · S/N 3418N9187SCarr Gary · Crestwood, ILBuilt 1976 · S/N MB-790N9188GAircraft Management Services Inc · Milton, FLBuilt 1979 · S/N 17273625N9188JBooth Emmett W · Waitsburg, WAS/N 28-3256N9188SVanommeren Matthew · Uniondale, NYBuilt 1976 · S/N M-1803N9189HPendergrass Aviation Inc · Demopolis, ALBuilt 1975 · S/N 17266002N9189JMileski William J · Ledyard, CTBuilt 1966 · S/N 28-3257N9189TBunselmeier Donald W · Delta Junction, AKBuilt 1979 · S/N 18-8009020N918FAWestways Aviation LLC · El Cajon, CABuilt 1981 · S/N 17274981N918JBBriggs Michael N · Mableton, GAS/N 918N918MBLive More LLC · Fort Worth, TXBuilt 2010 · S/N 20716N918MLCluff Omatthew M · Payson, AZBuilt 1987 · S/N 1016N918PMMathews Roy · Bay Shore, NYBuilt 1980 · S/N 172RG0602N918VPVanderpool Robert W · Red Devil, AKS/N 17266379N9190JLarchar William S · Rockledge, FLS/N 28-3258N9191JArmstrong Donald Bradford · Sterling, COBuilt 1966 · S/N 28-3259N9191N9191n LLC · Salem, NHBuilt 1989 · S/N 2890136N91925Rl Aviation LLC · Miami, FLBuilt 1973 · S/N 17261524N9192DHadley Sheldon L · Hope, ARS/N 22-6251N9192VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1965 · S/N 28-3268N9193GMach One Velocity LLC · Macomb Twp, MIBuilt 1979 · S/N 17273626N9193JGref Michael C · Murfreesboro, TNBuilt 1966 · S/N 28-3261N9194DDaniels Daryl A · Warren, OHBuilt 1958 · S/N 22-6253N9194JStange Robert C · Toledo, OHBuilt 1966 · S/N 28-3262
Back to AD 79-10-03 R2