OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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.

N2540FMcguires Flying Service LLC · Obion, TNBuilt 1965 · S/N 96N2540PReed Michael D · Parsons, KSBuilt 1955 · S/N 22-2903N2540QAmt Aero Inc · Massapequa, NYBuilt 1977 · S/N 28-7790404N2541SLanning Danny E · Alzada, MTBuilt 1979 · S/N 18-7909156N2543URegistered aircraftBuilt 1979 · S/N 28-8090055N2544PCoonfield Russell Adam · Fayetteville, ARBuilt 1955 · S/N 22-2907N2544SSunrise Adventures LLC · Stillwater, MNBuilt 1979 · S/N 18-7909155N2545PMatter Steven S · Joliet, ILFirst renewal noticeBuilt 1955 · S/N 22-2908N2545UMcmahon Patrick S · San Antonio, TXBuilt 1979 · S/N 28-8016032N2546CRaby Byrd J · Normandy, TNBuilt 1954 · S/N 26190N2546PDadez Jaime G · Browntown, WIS/N 22-2910N2546UL00 Fliers LLC · Lewes, DEBuilt 1979 · S/N 28-8016033N2546ZClark Brent R · Layton, UTBuilt 1977 · S/N 998-77N25471Cottingham Lon W · Kingwood, TXBuilt 1940 · S/N 1N2547HThree S Ranch · Blanca, COBuilt 1979 · S/N 18-7909198N2547QLawrence Thomas C · Memphis, TNBuilt 1977 · S/N 28-7725200N2547ZLecompte Francesca · Lancaster, MABuilt 1978 · S/N 261-78N2548QChristian Keith · Lighthouse Point, FLS/N 28-7716110N2549PLyons Andrew J · Mansfield, MABuilt 1955 · S/N 22-2913N2549QFly Legacy Planes LLC · Philadelphia, PABuilt 1977 · S/N 28-7716111N254AZShook Scott R · Gilbert, AZBuilt 2013 · S/N 72102N254BAas LLC · Ovid, MIBuilt 1957 · S/N 14N254KMFowler Michael J · Golden Valley, MNBuilt 1968 · S/N 17701076N254PDN22154 Inc · Wilmington, DEBuilt 2004 · S/N 3271N254RAReynolds Darryl G · Wills Point, TXBuilt 1975 · S/N 17265910N254RVDecamp Larry R · Clinton, INBuilt 2024 · S/N 4163N254SHTexxon Resources Inc · Winter Park, FLBuilt 1997 · S/N 24259N2550BSouthern Utah University · Cedar City, UTS/N 0611N2550MEarthcom Inc · Williamston, MIBuilt 1977 · S/N 28-7816292N2550YPramik Thomas J · Akron, OHBuilt 1985 · S/N 28-8516077N25511Gleason Randy H · Redding, CABuilt 1969 · S/N 28-25718N2551PLimoge Jerome P III · Colorado Springs, COBuilt 1955 · S/N 22-2915N2551UPizzuto Samuel J · Chamblee, GABuilt 1979 · S/N 28-8016034N2551ZHobson Simon · Eagle River, AKBuilt 1977 · S/N 999-77N2553WBrown Jeffrey B · Punta Gorda, FLBuilt 1965 · S/N 3265N2553YMacair Aviation LLC · Xenia, OHBuilt 1985 · S/N 28-8516079N25552Region Flyers LLC · Valparaiso, INBuilt 1985 · S/N 28-8516081N2555BHadden Fleming Cindy L · San Antonio, TXS/N 28-25678N2555PJohnson Alwyn J · Karlstad, MNBuilt 1955 · S/N 22-2889N2556MTennyson Chad E · Ridgefield, WABuilt 1946 · S/N 12-1040N2557PMcmahon Thomas F · Yakima, WABuilt 1955 · S/N 22-2920N2558LHoecher Robert · Anchorage, AKS/N 17255758N2559PSale Reported · Oklahoma City, OKSale reportedBuilt 1955 · S/N 22-2922N2559STrue Altitude LLC · Isola, MSBuilt 1979 · S/N 18-7909160N2559WHighfill Randall W · Hannibal, MOBuilt 1965 · S/N 3268N255LLChandler Elijah J S · Pilot Mountain, NCS/N 082N255PCWinger Michael J · Boulder Junction, WIBuilt 2002 · S/N 5173N255SCSouth Georgia Technical College · Americus, GABuilt 2005 · S/N 3772N255SFKcsi Aerial Patrol Inc · Bakersfield, CABuilt 2000 · S/N 1287-2000N255XKnop Courtney Dee · Vernal, UTS/N 20450
Back to AD 79-10-03 R2