OpenAirDocs.org
AD 87-21-02 R1

Registered aircraft · 3,961

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:87-21-02-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:87-21-02-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.

N6283QOn Glidepath Properties LLC · Gilbert, AZBuilt 1972 · S/N 310Q0492N628BWWings Like Eagles LLC · Wilmington, DES/N 310R0682N628JWJuliet Whiskey LLC · Roanoke, VABuilt 1979 · S/N 414A0241N628RJJanak Jeffrey · Corpus Christi, TXBuilt 1974 · S/N 421B-0503N628RKNicholas Adam J · Loomis, CAS/N 340A0946N6290NShrauner Reid · Elkhart, KSBuilt 1978 · S/N 340A0464N6292NAvjets LLC · Miami, FLFirst renewal noticeBuilt 1978 · S/N 340A0465N6297XMike Sierra LLC · Brookings, SDS/N 340A0468N629WMVortech LLC · Woodbury, NYS/N 421C1001N62DWSagamore Sky LLC · Jericho, NYS/N 4210188N62JCChuoke Joseph P · Texas City, TXS/N 421C0498N6301XRonald A Peterson Inc DBA · Orlando, FLBuilt 1978 · S/N 340A0472N6303XNelson Stephen C · Niwot, COS/N 340A0474N6304XAndriopulos Salguero Inc · Hialeah, FLBuilt 1978 · S/N 340A0475N6305XMurray Co · Compton, CABuilt 1978 · S/N 340A0476N630ADT Machine LLC · Livingston, MTBuilt 1977 · S/N 421C0406N630PLSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1981 · S/N 340A1224N6311XMatts Cats LLC · Osceola, WIBuilt 1978 · S/N 340A0482N6315XEagle Aviation LLC · Morristown, TNBuilt 1981 · S/N 421C1003N6316XLear Traase Kj · Roundup, MTS/N 340A0487N6319XWilliver Troy Lyn · Sherwood, ORBuilt 1978 · S/N 340A0490N631FHayes Terry E · Rockport, TXBuilt 1963 · S/N 39169N633MCSveen Jeffrey T · Aberdeen, SDBuilt 1979 · S/N 421C0657N635MAAirswiss Inc · Wilmington, DES/N 402C0634N636BTWestwind Digital Corp · Mahwah, NJBuilt 1972 · S/N 340-0168N636KKKnox Construction Inc · Verdi, NVBuilt 1977 · S/N 340A0290N6375XMiliano Air LLC · Lewes, DEBuilt 1978 · S/N 402B1338N6384XPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1978 · S/N 402B1347N6387XAir Exec Inc · Mount Pleasant, IABuilt 1978 · S/N 402B1350N6396XAviation Tech Services LLC · Edgewater, FLBuilt 1978 · S/N 402B1355N639SCSale Reported · Glen Allen, VASale reportedBuilt 1969 · S/N 421A0102N63CXAerodata LLC · Wilmington, DES/N 4140388N63DBDelta Properties Llp · Nogales, AZS/N 414A1211N63DETri-Air LLC · Cedartown, GABuilt 1972 · S/N 310Q0675N63ECAugend Arsalan · Chicago, ILBuilt 1976 · S/N 340A0121N63ENEcho November Inc Trustee · Wilmington, DES/N 340-0063N64310Aldrich Curtiss R · Big Oak Flat, CABuilt 1964 · S/N 310I0134N643WMBarham Investments LLC · Dexter, MOBuilt 1985 · S/N 414A1205N645WCWest Louis G · Amity, ORBuilt 1975 · S/N 414-0645N647TWWeigle Gerald V Jr Trustee · Cincinnati, OHBuilt 1973 · S/N 310Q0815N6486VVroom Engineering Inc · Tucson, AZBuilt 1984 · S/N T30300311N648SBHays Kelly · Dumas, TXBuilt 1979 · S/N 421C0648N6498VSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N T30300313N64KTKlute Jordan · Omaha, NEBuilt 1976 · S/N 340A0045N650BDV1vr LLC · Saint Louis, MOBuilt 1979 · S/N 414A0404N650DBValiair Limited Company Trustee · Casper, WYBuilt 1982 · S/N 414A0853N650RMAcci Aviation LLC · Conway, ARBuilt 1978 · S/N 414A0031N651DBJgm Icarus LLC · Centennial, COBuilt 1976 · S/N 340A0089N651RMackey Aviation LLC · Talking Rock, GABuilt 1960 · S/N 39261N652KWHauser Zachary D · Camp Verde, AZBuilt 1969 · S/N 310P0077
Back to AD 87-21-02 R1