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.

N4137PGreene Marble & Granite Co · Manalapan, NJBuilt 1999 · S/N 3257086N4137RDavis Charles E · Mount Dora, FLBuilt 1968 · S/N 32-40455N4138RReece Doyle · Bentonville, ARBuilt 1968 · S/N 32-40493N4139SKdj LLC · Wilmington, DEBuilt 1999 · S/N 3257099N4139TMalibu Mirage Inc · Eugene, ORFirst renewal noticeBuilt 1998 · S/N 4636179N4139VBourgogne Aviation Inc Owner Trustee · Wilmington, DEBuilt 1999 · S/N 3257085N413HCNeed For Speed LLC · Tyler, TXS/N 32R-8429012N413TCMcbeath Casey A · Shreveport, LABuilt 2005 · S/N T18208423N41408Drixhurst Six LLC · Lindon, UTBuilt 1974 · S/N 32-7440088N4140RStewart Mike F · Chugiak, AKBuilt 1968 · S/N 32-40459N4141BWright Eric K Sr · Wills Point, TXBuilt 1975 · S/N 75-32-160N4141GPon Douglas James · Chalfont, PABuilt 1999 · S/N 4636233N4141RHard Landing LLC · Fort Pierce, FLS/N 32-40460N4142WDale Mike S · Boise, IDBuilt 1967 · S/N 32-40210N4143RCon Air Aviation LLC · Borger, TXBuilt 1968 · S/N 32-40462N4144RRacer Investments LLC · Long Beach, CAS/N 32-40463N41469Shield Solutions LLC · West Plains, MOBuilt 2000 · S/N 3257154N4146PN4146p Saratoga LLC · Austin, TXBuilt 1999 · S/N 3257106N4147RRamos George L · Conroe, TXBuilt 1968 · S/N 32-40347N4147WRalls Michael Todd · Crawfordsville, IABuilt 1967 · S/N 32-40217N41492Charter Air Travel LLC · Mount Pleasant, SCBuilt 1999 · S/N 3257105N4149RClary Daniela · Sunnyvale, TXBuilt 1999 · S/N 4636226N414LBRegistered aircraftBuilt 1979 · S/N 14524N4150WMathews Brandon · Eunice, NMS/N 32-40221N41518Lechene Craig · Holly Springs, NCBuilt 2000 · S/N 46-36302N4151BCraig Scott W · Sorento, ILBuilt 1974 · S/N 75-32-152N4151PDaman Arthur C Trustee · Arroyo Grande, CABuilt 2000 · S/N 3257188N4151RMartin Michael T · Las Vegas, NVBuilt 1968 · S/N 32-40465N4152DSires Brian · Cedar Falls, IABuilt 2000 · S/N 46-36304N41545Faulks Carson · Wellington, TXS/N 32-7440097N4157EBel Air LLC · Henderson, KYBuilt 1984 · S/N 31P-8414047N4159RArmstrong Scott T · Navasota, TXBuilt 1968 · S/N 32-40474N4159WNorthern Sky Aviation LLC · Howard Lake, MNBuilt 1967 · S/N 32-40231N415SAArtemis Aviation Group LLC · Kalispell, MTBuilt 1954 · S/N 14064N415VAVel-Air Inc · Clifton, VABuilt 2000 · S/N 4636290N415WRN415wr LLC · Bogart, GAS/N 4636147N4160NSteele Howard Scott · Idaho Falls, IDBuilt 2000 · S/N 4636280N4162REckman Jason · Waterford, WIBuilt 1968 · S/N 32-40477N4162WBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 32-40235N4162ZSpirit Flyers Inc · Saint Louis, MOBuilt 2000 · S/N 3257127N4163DMiraza Aviation LLC · Longview, TXBuilt 2000 · S/N 32-57145N4163EAllied Aviators Inc · Allison Park, PABuilt 2000 · S/N 3257136N4163PMalibu Aviation LLC · Bloomfield Hills, MIBuilt 2000 · S/N 4636274N4163RFlying Javelina Aero-Club · Tucson, AZBuilt 1968 · S/N 32-40478N4165LValiair Limited Co Trustee · Tucson, AZS/N 3257129N41676American Roadways LLC · Missoula, MTBuilt 2000 · S/N 4636268N4167AWilliams Mirage LLC · Denver, COBuilt 2000 · S/N 46-36254N4167CSsp Aviation LLC · Aurora, OHBuilt 1999 · S/N 4636201N4167DCraft Air Ventures LLC · Lake Jackson, TXBuilt 2000 · S/N 3257138N4167NS&T Aviation LLC · Missoula, MTS/N 3257170
Back to AD 91-21-01 R1