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.

N4262RKirkpatrick Alan E · Oklahoma City, OKS/N 32-40636N4264AReed William B · Cortlandt Manor, NYBuilt 1947 · S/N NAV-4-606N4266RBig Guy Enterprise Transportation LLC · Portland, ORBuilt 1969 · S/N 32-40639N426PRRyka Aviation LLC · Sunrise Beach, MOBuilt 1999 · S/N 3257108N426SSale Reported · Kotzebue, AKSale reportedS/N 31-8152190N426SEAthena Aviation LLC · Golden, MSS/N 3255042N426TC3di LLC · Elizabeth, WVBuilt 1987 · S/N 4622001N4270RKreiser Foster E Jr · Middletown, PABuilt 1969 · S/N 32-40645N4270TAllen Aero LLC · Saint Cloud, FLBuilt 1971 · S/N 32-7240048N4272RModic David J · Escondido, CABuilt 1969 · S/N 32-40647N4277RFoxtrot Golf LLC · Kalispell, MTBuilt 1969 · S/N 32-40648N4279RCummins Dan D · Blencoe, IABuilt 1969 · S/N 32-40651N427ABSouthern Fabrication & Welding LLC · El Dorado, ARS/N 4636324N427JKMoore J R · Montgomery, TXBuilt 1997 · S/N 3246061N427WSMijares Miguel · Mcallen, TXBuilt 2001 · S/N 4636321N4280RRupp Amanda E · Osteen, FLBuilt 1969 · S/N 32-40653N4289RShaughnessy Paul V Jr · Norwood, MABuilt 1969 · S/N 32-40665N428RAN428ra LLC · Hampshire, ILFirst renewal noticeBuilt 1978 · S/N 32R-7887121N4290RLadet David E · Lavonia, GABuilt 1969 · S/N 32-40666N4292RSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 32-40669N4292SD&D Design Manufacturing Inc · Oklahoma City, OKBuilt 1983 · S/N 32R-8329014N4293RLaws Chris · Mckenzie, TNS/N 32-40671N4294PAex Enterprises LLC · Alexandria, LABuilt 1983 · S/N 32R-8329015N4296RJohnstone Colin · Enterprise, ALS/N 32-40674N4296TD'Haem Christopher M · East Lansing, MIBuilt 1983 · S/N 32-8324009N4296XWilco Consulting LLC · Elkhart Lake, WIBuilt 1983 · S/N 32-8324010N42979Dashanddash LLC · Athens, GABuilt 1983 · S/N 32R-8329021N4297CEv Aviation LLC · Elizabeth, COBuilt 1983 · S/N 32R-8329019N4297R4297 Romeo Aviation LLC · Owasso, OKBuilt 1969 · S/N 32-40675N4298RAv79 Aviation LLC · Dover, OHBuilt 1969 · S/N 32-40677N4299RRimlinger Timothy Trustee · Audubon, PABuilt 1969 · S/N 32-40678N4299XFerguson Teresa · Houston, ARBuilt 1983 · S/N 32-8324012N429FSSimmons Frederick G · Lake Hiawatha, NJBuilt 1971 · S/N 32-54N429HPJohn Allen Construction LLC · Big Sandy, TNBuilt 1971 · S/N 274695N42CXSilver Hawks Ltd · Columbus, OHBuilt 1973 · S/N 32-7340142N42FAEuroaviation Inc Trustee · KematenBuilt 1999 · S/N 27-0279N42HDMsm42h LLC · Jericho, NYBuilt 1980 · S/N 31-8152031N42HPLmtp Adventures LLC · Tucker, GABuilt 1976 · S/N 61P-0343-102N42HTP&M Partners LLC · Sumter, SCBuilt 1978 · S/N 31-7852106N42JDSpeegle Aviation LLC · Albuquerque, NMBuilt 2000 · S/N 27-0303N42MHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1977 · S/N 31-7852015N42RCRci Air Inc · Bridgeport, CTBuilt 1980 · S/N 31-8052170N42RTMonette Michael · Dallas, TXBuilt 1983 · S/N 32R-8329030N42TGMurray Frederick D · Evans, GAS/N 684N42WPAir Arctic Inc · Fairbanks, AKBuilt 1982 · S/N 31-8252038N4301C70 North LLC · Anchorage, AKBuilt 1983 · S/N 31-8353001N4301FNewberg Curtis · Willmar, MNBuilt 1976 · S/N 32R-7680433N4304LExplorer Sky Ventures LLC · Newark, DEBuilt 1983 · S/N 32R-8329027N4306FN4306f Inc · Winter Haven, FLBuilt 1976 · S/N 32R-7680434N4306VArchwell Aviation LLC · Glendale, AZS/N 32R-8329028
Back to AD 91-21-01 R1