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.

N5839RGiraud Stephen · Box Elder, SDBuilt 1995 · S/N 20042CN583FLSotomayor Edwin · Lacey, WABuilt 1971 · S/N 28-7125438N5840UTall Timber Flying Service LLC · Kalispell, MTBuilt 1970 · S/N 28-26671N5841DLeopold Gary L · Winterset, IABuilt 1956 · S/N 22-4520N5841WDestination Flyer LLC · Memphis, TNBuilt 1965 · S/N 28-2216N5842LBerner Walter T III · Stamford, CTBuilt 1972 · S/N AA5-0042N5842QBradford Michael · San Jose, CABuilt 1965 · S/N 3130N5842WFrakes Enterprises · Happy, TXBuilt 1965 · S/N 28-2221N5843LMaschek Scott · Harker Heights, TXBuilt 1972 · S/N AA5-0043N5843UOnyx Aviation LLC · North Fort Myers, FLS/N 28-26674N5843WSkyunityventures LLC · Richmond Hill, NYBuilt 1965 · S/N 28-2247N5844LHennell Elizabeth · Orrville, OHBuilt 1972 · S/N AA5-0044N5844WSmith William H · Weimar, TXBuilt 1965 · S/N 28-2237N5845LKunkel Dennis J Co Trustee · Clearwater, MNBuilt 1972 · S/N AA5-0045N5846FDunning Steve L · Hopkinsville, KYBuilt 1976 · S/N 28-7790138N5846QGardner Perry F · East Canaan, CTBuilt 1965 · S/N 3132N5847PMyers Michael A · Indianapolis, INBuilt 1959 · S/N 24-928N5847UFly Vermont LLC · Swanton, VTBuilt 1969 · S/N 28-26678N5847WReed Charles W · Elizabeth City, NCBuilt 1965 · S/N 28-2286N5847XFowler Leo W · Port Alsworth, AKBuilt 1941 · S/N 7896N5848AKnight Farms Inc · Pasco, WAS/N 001JRAN5848LN5848l LLC · San Francisco, CABuilt 1972 · S/N AA5-0248N5848QValenti Edgar M · Gig Harbor, WABuilt 1965 · S/N 3133N5848WLedbetter Mark W · Garfield, ARBuilt 1965 · S/N 28-2292N58490Kushner Herbert A · Bridgewater, NJBuilt 1997 · S/N 1094N5849FGng LLC · Arlington, INBuilt 1976 · S/N 28-7790139N5849WHomic Michael J · Edmond, OKBuilt 1965 · S/N 28-2293N584FBenesch Benjamin · Sparks, NVBuilt 2000 · S/N 5084N584FLQuantum Aviation Services LLC · Lakewood Ranch, FLBuilt 1971 · S/N 28-7125439N584KButterfield Rory A · Milan, NMBuilt 1975 · S/N 584N584LLawver William A · Panama City, FLBuilt 1972 · S/N AA5-0084N584LKTipton William M · Burlington, NCBuilt 1999 · S/N 103MN584SFDsr Cherokee 180 LLC · Dallas, TXBuilt 1968 · S/N 17256834N5850LXeus Inc · Nottingham, PABuilt 1972 · S/N AA5-0050N5850QMcmoran Donald W · Mount Vernon, WAS/N 3134N5850UMarfair LLC · Freeport, TXBuilt 1970 · S/N 28-26681N5850WCaside Aviation LLC · Brooklyn, NYBuilt 1965 · S/N 28-2296N5851DRubbert Lorin E · Reynolds, NDBuilt 1956 · S/N 22-4530N5851LOretsky Philip H · South Haven, MIBuilt 1972 · S/N AA5-0051N5851UFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1969 · S/N 28-26683N5851VMcconnell Thomas E · Grass Valley, CABuilt 1977 · S/N 28-7715273N5851WCameron Hugh R · Gainesboro, TNBuilt 1965 · S/N 28-2308N5852LOhser David G · Hudson, FLBuilt 1972 · S/N AA5-0052N5852QOldham Jared K · Richfield, WIBuilt 1965 · S/N 3135N5852WFerguson Carl R · Waupaca, WIBuilt 1965 · S/N 28-2312N5853DHapka Leon J · Halma, MNBuilt 1956 · S/N 22-4532N5853LKennedy Samuel E · Watsonville, CABuilt 1972 · S/N AA5-0053N5853PLewellen Walter G · Moreno Valley, CABuilt 1959 · S/N 24-935N5853UPost Jay M · Greenfield, OHBuilt 1970 · S/N 28-26685N5854DPro West Air LLC · West Point, UTS/N 22-4533
Back to AD 79-10-03 R2