OpenAirDocs.org
AD 91-21-01 R1

Registered aircraft · 5,086

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

N21352Lane Shannon L · Hopkinsville, KYBuilt 1978 · S/N 32R-7885252N21356Elite Financial Management Inc · Dallas, TXBuilt 1978 · S/N 32R-7887202N21357Wild Outdoors Oil LLC · Velma, OKBuilt 1978 · S/N 32R-7887203N21372Halbert Ronald S · San Diego, CABuilt 1978 · S/N 32R-7887204N2137EMbg LLC · Mountain Home, IDBuilt 1997 · S/N 27-0230N2138BSouthwest Aviation Enterprises · Haslet, TXBuilt 2003 · S/N T20608437N2138FCima Christopher P · Plano, TXBuilt 1979 · S/N 32R-7987065N2138KGrigsby Aaron A · Victorville, CABuilt 1978 · S/N 32R-7987070N2139KPolly P LLC · Fort Worth, TXBuilt 1999 · S/N 27-0271N213ACRtb Transport LLC · Evans, GABuilt 1984 · S/N 31-8452011N21406Makushin Logistics LLC · Fairbanks, AKS/N 31-7752117N21425Nelson Phillip · Jonesboro, ARS/N 32R-7887207N2142SDbm Farms Inc · Clarksdale, MSBuilt 2003 · S/N T18208224N21435Car Guys Aviation LLC · Lead, SDBuilt 1978 · S/N 32R-7887210N21436Smith Michael W · Bracey, VABuilt 1978 · S/N 32R-7887211N2143BLance Aviation Corp · Houston, TXBuilt 1978 · S/N 32R-7987028N21459N21459 LLC · Farmington Hills, MIBuilt 1978 · S/N 32R-7887212N2145RCabernet To Cactus LLC · Scottsdale, AZBuilt 2003 · S/N T20608427N21469Blubaugh Patrick S · Inyokern, CABuilt 1978 · S/N 32R-7887214N2148BKaroudjian David · Savannah, GAS/N 32R-7987030N2148WSav LLC · Shelton, WABuilt 2003 · S/N T20608421N21493Macmillan Robert J · Merritt Island, FLBuilt 2003 · S/N T20608423N21494Dmc Air LLC · West Chester, OHS/N 32R-7887216N21499Kling Clint W · Summerset, SDBuilt 1978 · S/N 32R-7887218N214BPHolmes Aviation Inc · Webster, FLBuilt 2000 · S/N 3257156N214HSDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1975 · S/N 27-7654014N2150BGreen Head Flight Services LLC · Bemidji, MNBuilt 1979 · S/N 32R-7987031N2150KCarey David John II · Mccall, IDBuilt 2003 · S/N T20608407N2151YMtjc Services LLC · Chester, WVBuilt 2003 · S/N T18208207N2153NEagle Air US Inc · Eau Claire, WIBuilt 1979 · S/N 32R-7987096N2153VGoro Sky Aircraft LLC · Lino Lakes, MNBuilt 1999 · S/N 27-0272N2154XVital Sync LLC · Lakeway, TXS/N 27-0243N2155JSlickhorns LLC · Reno, NVS/N T18208209N2156EMaarouf Dan H · Taylor Village, TXBuilt 1978 · S/N 32R-7987062N2156NTerryair LLC · Missoula, MTBuilt 2003 · S/N T20608409N2157NC A R S Sales Inc · Denver, NCBuilt 1979 · S/N 32R-7987097N2159PKiehn Real Estate LLC · Santa Barbara, CABuilt 2003 · S/N T20608432N2161AHoyer Chase R · Jarrell, TXBuilt 1978 · S/N 32R-7985003N2162WHelicopter Applicators LLC · Pembroke, NHBuilt 2004 · S/N T20608439N2165KAustin David · Cypress, TXBuilt 1999 · S/N 27-0259N21683Flying H Inc · Hoxie, KSBuilt 1978 · S/N 32-7840188N2168BBonjour Hugo E · Houston, TXBuilt 1978 · S/N 32R-7987032N2168FDean William R · Webster Springs, WVBuilt 1999 · S/N 27-0261N2168JAirgus LLC · Henderson, NVBuilt 1999 · S/N 27-0265N216DCDornink Steven R · Birchwood, WIBuilt 2000 · S/N 18280898N216PWPapa Whiskey LLC · Chicago, ILBuilt 2002 · S/N 3257304N216SBMorotti John M · Las Vegas, NVBuilt 2004 · S/N T20608463N2170WSacks Martin · Mill Valley, CABuilt 2005 · S/N T18208441N2171BCleary Kevin W Trustee · Glendale, AZBuilt 1979 · S/N 32R-7987033N2171QAmster Richard B · Brookline, MABuilt 1999 · S/N 27-0262
Back to AD 91-21-01 R1