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.

N488KRedcell Air Inc · Miami, FLBuilt 1976 · S/N 421C0078N488SSale Reported · Friday Harbor, WASale reported, pending cancellationS/N 4140529N488SJDeans Casing Service Inc · Holdenville, OKFirst renewal noticeBuilt 1977 · S/N 414-0959N488SPSugarpop Air LLC · Chicago, ILBuilt 1967 · S/N 310N-0029N48AMGwc Air LLC · Madison, ALBuilt 1980 · S/N 414A0609N48BPRossman Richard J DBA · Glenview, ILBuilt 1975 · S/N 421B0957N48CPDouglas Aviation Ltd · South Barrington, ILS/N 421C0902N48SAUltra Aviation Management Inc · Miami, FLBuilt 1979 · S/N 404-0417N4905AAnderson Ryan Alexander · Minnetrista, MNBuilt 1978 · S/N 310R1397N490KMRasf414 LLC · Hallandale Beach, FLS/N 414-0399N4927AGenx Aviation LLC · Leesburg, VABuilt 1978 · S/N 310R1504N4937JSwirsding David J · Chalfont, PABuilt 1977 · S/N 310R0952N4938AK E R Air LLC · Fort Myers, FLBuilt 1978 · S/N 310R1406N493JHBrooklyn LLC · Parker, COS/N 421C0860N4941AMartinello Domenic · Clarksville, TNBuilt 1978 · S/N 310R1407N4948AKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1410N4949ASw Air LLC · Denver, COS/N 310R1505N4949CHatchie River Aviation LLC · Kalispell, MTBuilt 1982 · S/N T30300128N494BCHyannis Air Service Inc · Hyannis, MAS/N 402C0308N494TSDeep Creek Lake Ventures LLC · Oakland, MDBuilt 1983 · S/N T30300201N494WKingsbury Raymond S · Farmington, MNS/N 310K0103N495495htsi LLC · Wilmington, DEBuilt 1980 · S/N 414A0487N497JMBazzi Aviation LLC · Newark, DEBuilt 1972 · S/N 310Q0497N498DASmm Leasing LLC · Camp Verde, AZBuilt 1975 · S/N 310R0278N499ATN633at LLC · Punta Gorda, FLS/N 414A0306N499CAHyannis Air Service Inc · Hyannis, MABuilt 1985 · S/N 402C1006N499WWLakes Air LLC · Fargo, NDBuilt 1966 · S/N 411-0161N49ARMoore Thomas A · Kennewick, WAS/N 421B0563N4ADValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 421B0467N4AFN4af LLC · Conroe, TXBuilt 1968 · S/N 421-0142N4AS310 Air Ltd · Seville, OHBuilt 1964 · S/N 310I0094N4FAOgburn Benjamin R · Fernandina Beach, FLBuilt 1976 · S/N 310R0700N4GKDalessandro Janet E · Park Falls, WIBuilt 1975 · S/N 310R0219N4HAArrington Harold M · Detroit, MIBuilt 1984 · S/N T30300283N4MUBlusky Properties & Investments LLC · Cameron, MOBuilt 1970 · S/N 421B0054N4MZBank Of Utah Trustee · Salt Lake City, UTS/N 421C0829N4PJAnderson Richmond E Jr · Orlando, FLBuilt 1972 · S/N 310Q-0515N4VHFoster Chad H Jr · Uvalde, TXBuilt 1977 · S/N 421C0435N5000UMci Air LLC · Wilmington, DEBuilt 1979 · S/N 414A0318N5005JDowding Industries Inc · Eaton Rapids, MIBuilt 1974 · S/N 310R0129N5008JR C Construction Co Inc · Greenwood, MSBuilt 1975 · S/N 310R0132N5009QWeed Ryan W · San Francisco, CABuilt 1968 · S/N 310N-0109N500AWMcnulty Kim E · Tehachapi, CAS/N 310R0077N500CHAchiro David P · Truckee, CABuilt 1976 · S/N 310R0734N500CTLac Aero LLC · Liberal, KSBuilt 1981 · S/N 340A1236N500EBKaizen Aircraft Holdings LLC · Kalispell, MTBuilt 1977 · S/N 340A0287N500QVJands LLC · Broken Arrow, OKBuilt 1979 · S/N 340A0699N500RFJones Anthony Blake · Sylacauga, ALBuilt 1968 · S/N 310P0026N500SHMergili Joseph P · El Paso, TXBuilt 1968 · S/N 310N-0108N500TJAirbyars LLC · Spartanburg, SCBuilt 1974 · S/N 421B0585
Back to AD 87-21-02 R1