OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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.

N3168WBlack Gold Flying Club Inc · Belvidere, NJBuilt 1974 · S/N E-510N3169WCoelho Enterprises Inc · Dayton, NVBuilt 1974 · S/N E-512N316BEyefly Az Inc · Hereford, AZBuilt 1956 · S/N D-4811N316BMPrice John DBA · Bennington, KSS/N D-3268N316EWhiskey Papa LLC · Denver, COS/N P-550N316JGKoch Eric R · Jasper, TXBuilt 1982 · S/N E-2038N316NFSteenland Mark R II · Killeen, TXBuilt 1963 · S/N M-473N316PAkin Products Inc · Monticello, ARBuilt 1999 · S/N E-3237N31707Bankruptcy Services LLC · Wilmington, DEFirst renewal noticeBuilt 1988 · S/N CE-1287N31708Albatross Air Inc · Beaver, WVS/N EA-486N3170FO'Neill Matthew · Indianapolis, INBuilt 1988 · S/N E-2407N3172DNorth State Aviators LLC · Cary, NCBuilt 1988 · S/N E-2454N3172KAnderson Stephen · Loveland, COBuilt 1988 · S/N E-2435N3173TAir Tango LLC · Martinez, GABuilt 1988 · S/N CE-1259N3173WFlying Hammer Aviation LLC · Crosslake, MNBuilt 1974 · S/N E-513N3174KLrs Dynamics Corp · Port Orange, FLBuilt 1988 · S/N CE-1265N3175PBarlow Michael Kevin · Griffin, GABuilt 1986 · S/N CE-1091N3175WKristoffer & Co · Jacksonville, FLBuilt 1973 · S/N TC-1614N3176WTarvair Eclipse LLC · Burnsville, NCBuilt 1988 · S/N E-2447N3177NBcs99 LLC · Peoria, ILBuilt 1988 · S/N E-2440N317BPeck James L Jr · Shreveport, LABuilt 1956 · S/N D-4816N317BDRegistered aircraftBuilt 1967 · S/N TE-317N317CAspn Aero LLC · Ostrander, OHBuilt 1995 · S/N EA-574N317CHCrestair Air LLC · Dover, DEBuilt 1973 · S/N D-9543N317EPMcelligott Michael J · Woodstock, VABuilt 1969 · S/N D-9044N317MHWalton Cheryl H · Indianapolis, INBuilt 1959 · S/N BA-440N317SCDuehring Jonathan H · Raleigh, NCBuilt 1968 · S/N D-8754N317SWMcnaughton Aviation LLC · Bondurant, IABuilt 1965 · S/N D-7854N317ZNew William C · Hemet, CABuilt 1960 · S/N D-6540N3180WPepe Charles · Morrisville, VTBuilt 1974 · S/N D-9574N3181UBig Sky Aviation LLC · Ridgeland, MSBuilt 1994 · S/N EA-563N3181WNormark Jordan C · Granbury, TXBuilt 1974 · S/N D-9575N3182WOutstate Air Taxi Inc · Windom, MNBuilt 1974 · S/N CE-482N3185CThree Pipers Piping LLC · Charleston, SCBuilt 2000 · S/N E-3324N3189MSnowbird Aviation Corp · Signal Mountain, TNBuilt 2000 · S/N E-3325N3189YSkotynsky Michael · Broomfield, COBuilt 2001 · S/N E-3389N318ALeaders Robert O · Clear Lake, MNBuilt 1966 · S/N TE-229N318BRobinson Jay · Red Creek, NYBuilt 1956 · S/N D-4817N318DSchutes John T · Brimfield, MABuilt 1967 · S/N TE-311N318JSilver Eagle LLC · Kenedy, TXBuilt 2003 · S/N E-3526N3191APasternak Eliezer Trustee · Palo Alto, CABuilt 1999 · S/N E-3291N3192WJ M Beech Inc · Wilmington, DEBuilt 1974 · S/N E-521N3193XBlh Visions Mt LLC · Polson, MTBuilt 1994 · S/N E-2907N3194CNortje Bryan John · Gold Hill, NCBuilt 1967 · S/N D-8479N3195XAirbonanza LLC · Fort Myers, FLFirst renewal noticeS/N E-3295N3196AKloker Daniel E · Owasso, OKBuilt 1994 · S/N E-2885N3197MBonanza Five Flying Club Inc · Roswell, GABuilt 1994 · S/N E-2887N3197WMoskin Jeffrey M · Culver City, CAS/N TC-1658N3198LKatsahnias George T · Denton, TXBuilt 1994 · S/N E-2898N3198WRobert And Donna Odegaard Family Lllp II · Kindred, NDBuilt 1974 · S/N TC-1647
Back to AD 99-05-13 R1 WD