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.

N6675JReece Aviation LLC · North Clarendon, VTBuilt 1968 · S/N 28-24362N6676JRozof Chester F · Fort Myers, FLBuilt 1968 · S/N 28-24363N6676RJackson Michael W · Bedford, TXBuilt 1964 · S/N 2866N6676WWorkman Industries Inc · Durant, IABuilt 1965 · S/N 28-20783N6677HPeterson Robert E · Richland, WABuilt 1975 · S/N 17265533N6677WOsgood Darrell F · Watervliet, MIBuilt 1965 · S/N 28-20784N6678FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 28-7715175N6678JWiener Ronald K · Tucson, AZBuilt 1968 · S/N 28-24365N6678WMadison Andrew J · Inver Grove, MNS/N 28-20786N6679UKimbrough Edward W · Houston, TXS/N 2513N667BAAmendala Brian R · Hillsboro, ORS/N R669N667CRKnieling Gene A · Rush Center, KSBuilt 2000 · S/N 25317N667LDLeading Edge Aviation LLC · Manchester, MOS/N 1355N667QTevik Michael A · Provo, UTBuilt 1959 · S/N TD-260N667TCT J Aviation LLC · Kennesaw, GABuilt 1988 · S/N 960N6680EPrax Philip · Fairbanks, AKBuilt 1959 · S/N 56180N6680JElliott Bryn · Blue Point, NYS/N 28-24368N6681UGriffin Josh R · Minot, NDS/N 2408N6682LDeyo Kenneth F · Thomaston, CTBuilt 1970 · S/N 445N6682RCavazos Jose Luis Jr · Houston, TXBuilt 1964 · S/N 2867N66836Wolgemuth Jim · Anchorage, AKS/N 18-7709039N6683UReisner Kenneth D · Lecompte, LAS/N 2410N66842Gelvin Stanley M · Central, AKBuilt 1977 · S/N 18-7709140N6684WWaltman Richard Dean · Moses Lake, WAFirst renewal noticeBuilt 1965 · S/N 28-20790N6685UMccroskey Wesley D · Kingston, TNBuilt 1963 · S/N 2412N6685WZulueta David · Louisville, GAS/N 28-20791N6686UNorstegaard Mark A · Sturgis, SDBuilt 1963 · S/N 2413N6687CHurtt Ben J · Mountain Grove, MOBuilt 1947 · S/N 123372N6687JRio Creek Aviators Ltd · Casco, WIBuilt 1968 · S/N 28-24377N6687WHolland William A · Brownwood, TXBuilt 1965 · S/N 28-20794N66884Sea2ski Flying Club Inc · Anchorage, AKBuilt 1975 · S/N 18-7509090N6688WArkansas Air Expeditions And Instruction LLC · Greenbrier, ARBuilt 1965 · S/N 28-20795N66898Registration Pending · Haines, AKRegistration pendingBuilt 1975 · S/N 18-7509091N6689UStillman Troy C · Neenah, WIBuilt 1963 · S/N 2416N6689WStoll Jared M · Burnt Hills, NYBuilt 1965 · S/N 28-20796N668BNBelter Randolph K · Zachary, LABuilt 1984 · S/N EM-1N668LStarr Larry D · Gold Hill, NCBuilt 1991 · S/N 122N668PTCooper Michael T · Manson, IABuilt 2023 · S/N 001N668QUnruly Passengers LLC · Piedmont, SCS/N TD-326N668RVForester James C · Trenton, GAS/N 80066N66908Herman Timothy R · Presho, SDBuilt 1975 · S/N 18-7509093N6690DMiesko Martin A · Sprng Brk Twp, PABuilt 1954 · S/N 18-3848N6690JJones Michael A · Chateaugay, NYBuilt 1968 · S/N 28-24380N6691USchleis Ralph F · Manitowoc, WIBuilt 1963 · S/N 2418N6691WN6691w LLC · Nazareth, PABuilt 1965 · S/N 28-20799N6693HSwithenbank Leonard Co-Trustee · Fort Bragg, CABuilt 1975 · S/N 17265539N6693JOgrady Thomas · Franklin Square, NYS/N 28-24385N6693UShapiro Kier I · Oxnard, CABuilt 1963 · S/N 2420N6694EThunderbird Aviation LLC · Littleton, COBuilt 1978 · S/N 17272050N6694JStegemoller Adam Dean · Lewisville, TXBuilt 1968 · S/N 28-24387
Back to AD 79-10-03 R2