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.

N72045Pembroke Flyers LLC · Pembroke, NHBuilt 1984 · S/N CE-1042N7204EOverit Air LLC · Las Vegas, NVBuilt 1984 · S/N TJ-457N7205BBodo Martin J · Los Altos Hills, CABuilt 1958 · S/N D-5503N7205EAl Force 1 LLC · North Salt Lake, UTBuilt 1984 · S/N TJ-458N7206BSt Andrews Systems LLC · Navarre, FLBuilt 1984 · S/N CE-1043N7206DCrazy Plane LLC · Saint Augustine, FLBuilt 1984 · S/N EA-435N7207KWhitehead John · Cresson, TXBuilt 1984 · S/N E-2186N7207LSparkman Aviation · Odessa, TXBuilt 1984 · S/N EA-438N7207YBig Game Air LLC · Wilmington, DEBuilt 1984 · S/N E-2187N7208MTahoe Aviation LLC · Reno, NVBuilt 1984 · S/N E-2188N7208RBelford Mark C · Sammamish, WABuilt 1974 · S/N D-9699N7209EExecutive 21 LLC · Kansas City, MOBuilt 1985 · S/N CE-1046N720DApplied Professional Solutions Llp · Jacksonville, FLBuilt 1951 · S/N D-2991N720DWCatalina Sierra Inc · Wilmington, DEFirst renewal noticeBuilt 1970 · S/N CJ-30N720NWNunez Frank · Orlando, FLBuilt 1978 · S/N M-2079N720PMPeter J Messina & Associates Ltd · West Chicago, ILBuilt 1977 · S/N P-449N720TMinter Michael D Jr · Rock Port, MOBuilt 1975 · S/N D-9813N72100Klein John C · Indianapolis, INBuilt 1984 · S/N E-2196N72108Osprey 72108 LLC · Macon, GABuilt 1984 · S/N E-2197N7210LPescetti Investigation Services LLC · Carmichael, CABuilt 1984 · S/N E-2215N72121I Fly Planes LLC · Tulsa, OKBuilt 1984 · S/N E-2202N72124Fuller Kenneth C · Studio City, CABuilt 1984 · S/N CE-1047N7212BRegistration Pending · Boise, IDRegistration pendingS/N D-5522N7212URegistered aircraftBuilt 1984 · S/N E-2201N7213MTulip City Air LLC · Pella, IABuilt 1984 · S/N E-2206N7214BCoffman Robert P · Bigfork, MTBuilt 1958 · S/N D-5574N7214DWaheguru Holdings LLC · Corvallis, ORS/N E-2210N7215AGayler Granville II E · Rio Verde, AZBuilt 1984 · S/N E-2213N7215BCressler Keith R · Hoxie, KSBuilt 1958 · S/N D-5534N7215RBarnhart William C III · Whitewood, SDBuilt 1976 · S/N TC-1944N7216BSudweeks Will · Overton, TXBuilt 1958 · S/N D-5633N7216REncore Air LLC · Dover, DEBuilt 1974 · S/N TC-1820N7217BChavoustie Graham · Alexandria Bay, NYBuilt 1958 · S/N D-5546N7218HBoston Robert G · Atlanta, GABuilt 1985 · S/N CE-1056N7218RCourtney James Trustee · Menlo Park, CABuilt 1974 · S/N E-616N7218SRegistered aircraftBuilt 1984 · S/N CE-1051N72191Nantz William G Jr · Raleigh, NCBuilt 1955 · S/N D-4229N7219BDel Tex Flyers Inc · Olton, TXBuilt 1958 · S/N D-5558N7219CDesigns International Inc · Johnston, RIBuilt 1984 · S/N CE-1052N7219UHolt Daniel E Jr · Fayetteville, TNBuilt 1984 · S/N CE-1053N721BStandel David · Jacksonville, FLBuilt 1956 · S/N DH-115N721DKRegistration Pending · Fountain Hills, AZRegistration pendingBuilt 1997 · S/N E-3123N721JPTkw Properties & Investments LLC · St Simons Island, GABuilt 2002 · S/N E-3470N721KHBruce Mike · Evadale, TXFirst renewal noticeBuilt 1984 · S/N E-2214N721RSStill Charles · Fountain Valley, CABuilt 1966 · S/N D-8086N721RTAbbott R Barry · Sterling, AKBuilt 1968 · S/N M-1170N721TRDe Anza Building & Maintenance Inc · Los Altos, CABuilt 1981 · S/N P-571N721WTop Flight Aviation LLC · Kingfisher, OKBuilt 1972 · S/N D-9361N7220B6l6 LLC · Ross, CABuilt 1984 · S/N EA-425N72211Fly Oasis LLC · Addison, TXBuilt 1984 · S/N E-2218
Back to AD 99-05-13 R1 WD