OpenAirDocs.org
AD 75-06-01

Registered aircraft · 2,832

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:75-06-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-06-01')
  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.

N117NURegistered aircraftBuilt 1998 · S/N 4636138N117PWCommand Air LLC · Arlington, VABuilt 2001 · S/N 4697030N117TJCoastal Community Real Estate Group LLC · Caswell Beach, NCBuilt 1980 · S/N LA17N1188G207rs LLC · Santa Feon, NMBuilt 1984 · S/N 425-0202N118AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N 468508019N118KTKranze Technology Solutions Inc · Des Plaines, ILBuilt 2004 · S/N 208B1077N118MDAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-118N118SBEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1541N119QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 119N119WGHigh Performance Helicopters Corp · Crestline, CABuilt 2005 · S/N 14502N11DGAir Grace LLC · Blanco, TXBuilt 2024 · S/N K060N120KQMission Aviation Fellowship · Nampa, IDBuilt 2014 · S/N 100-0120N120QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 120N120RLIsr Platforms LLC · Mclean, VABuilt 1979 · S/N BT-9N120WWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2001 · S/N 4697047N1213SWright Caravan LLC · Seattle, WABuilt 1995 · S/N 20800243N12155International Air Services Inc Trustee · Carson City, NVBuilt 1996 · S/N 208B0562N121CMSpace Coast Aircraft Co · Merritt Island, FLBuilt 1993 · S/N 208B0336N121HARedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0069N121JPChoice Farms LLC · Wilmington, DEBuilt 1998 · S/N LJ-1520N121LHTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 425501049N121TDRegistration Pending · Montgomery, ALRegistration pendingBuilt 1979 · S/N 78-23138N1222BKelly Douglas E · Bethesda, MDBuilt 1980 · S/N 425-0060N1224WMaco Aviation Inc · Dayton, WABuilt 1998 · S/N 502A-0496N1229CKalinin Partners LLC · Juneau, AKBuilt 1996 · S/N 208B0589N1229ZKalinin Partners LLC · Juneau, AKBuilt 2002 · S/N 208B0943N122BKFlying Mixers LLC · Amarillo, TXBuilt 1999 · S/N BB-1651N122JBWestwind Aircraft Leasing LLC · Phoenix, AZBuilt 2003 · S/N 208B1025N122UCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B32N122UXAlpine Aviation Inc · Provo, UTBuilt 1994 · S/N UE-122N123FWBhmp King Air LLC · Fort Worth, TXBuilt 2001 · S/N LJ-1655N123FXFreefall Express · Gardiner, NYBuilt 1969 · S/N 200N123KQValiair Lc Trustee · Casper, WYBuilt 2009 · S/N 100-0013N123MLNfbn LLC · Scottsdale, AZBuilt 1997 · S/N BB-1587N123TPatey Michael J · Spanish Fork, UTBuilt 2008 · S/N 00060024N1242YSkydive Baltimore LLC · Lincoln, DEBuilt 2002 · S/N 208B0939N124EBPremium Air LLC · Hibbing, MNBuilt 1995 · S/N FL-126N1256PPlanemasters Ltd · West Chicago, ILBuilt 1996 · S/N 208B0564N125TECj Brown Express LLC · Graettinger, IABuilt 1992 · S/N BB-1422N125ZUsda Forest Service · Boise, IDBuilt 2017 · S/N 100-0226N12666Wdr Inc · Grand Forks, NDBuilt 1996 · S/N 20800250N126JHM&P Aviation LLC · Lakeland, TNBuilt 1980 · S/N BB-595N1276YJet Rider LLC · Middletown, DEBuilt 2005 · S/N 208B1113N127ARAircraft Unlimited Inc · Pierre, SDBuilt 2004 · S/N 208B1055N127AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC76N127GABeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB312N12813Razor Aviation Corp · Kalispell, MTBuilt 2000 · S/N 208B0808N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87N128STJet Rider LLC · Middletown, DEBuilt 2005 · S/N 208B1133N128VTState Of Missouri · Jefferson City, MOBuilt 1992 · S/N BB-1442
Back to AD 75-06-01