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.

N653JRMosquito Air LLC · Lewes, DEBuilt 1979 · S/N 340A0726N654DEDill Brice R · Glendale, AZBuilt 1978 · S/N 310R1428N6554XFly Like A Boss Aviation LLC · Minden, NVBuilt 1967 · S/N 310L0179N6561CTrtc Aviation LLC · Byron Center, MIBuilt 1977 · S/N 414A0014N6578CPapoose Air II LLC · Wilmington, DEBuilt 1978 · S/N 414A0020N657WMRegistration Pending · Carlsbad, NMRegistration pendingS/N 421C0474N6582Phoenix Aviation LLC · Bonaire, GABuilt 1976 · S/N 340A0125N6594CMaiden Assets LLC · Norfolk, VABuilt 1980 · S/N 335-0056N6597CHai Services Inc · Haltom City, TXBuilt 1978 · S/N 414A0028N6599GPremiere Aviation Inc · Concord, CAS/N 421C0275N659RJFoerstel Edward · Miami Beach, FLBuilt 1984 · S/N 421C1408N65AEMorris Charles J · Rutherford, TNBuilt 1975 · S/N 421B0953N65CPSparrowhawk Aviation LLC · Sugar Creek, MOS/N 310R0878N65DBrowndog LLC · Lksid Marblhd, OHBuilt 1972 · S/N 3400092N65RPE-Co Aviation LLC · Wilmington, DEBuilt 1979 · S/N 414A0287N660CABank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 402C0406N6614CBg Air Corp · Wilmington, DEBuilt 1978 · S/N 414A0032N662RKlotz Douglas · Incline Village, NVBuilt 1960 · S/N 39102N6631CD Porter Enterprises LLC · Dickinson, NDBuilt 1978 · S/N 414A0038N6633TC C I C Aircraft Division One LLC · Kalispell, MTBuilt 1977 · S/N 421C-0277N663AAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C-0123N6640CGospel Ministries International Inc · Collegedale, TNBuilt 1978 · S/N 414A0044N6644QLomakin Anatol · Lincoln Park, NJBuilt 1974 · S/N 414-0543N664RRobertello Gerald J · Centreville, VABuilt 1960 · S/N 39082N664RJGeneva Lakes Aviation LLC · Lake Geneva, WIBuilt 1975 · S/N 402B0854N664SKenney Michael D · Lucas, TXBuilt 1978 · S/N 421C0467N66552Janak Jeffrey · Corpus Christi, TXBuilt 1963 · S/N 320B0003N665SCGold Star Beacon LLC · Sarasota, FLBuilt 1975 · S/N 340A0006N6672CBayview Direct LLC · Dover, DEBuilt 1978 · S/N 414A0053N6674CAire Tracks Corp · Wilmington, DEBuilt 1980 · S/N 335-0058N6675QLoyal Aviation LLC · Loyal, WIBuilt 1973 · S/N 421B0442N669JMMerrell Bros Aviation LLC · Kokomo, INBuilt 1980 · S/N 340A0971N66CLLiberty Eagle LLC · Helena, MTBuilt 1980 · S/N 421C1019N66CWSpannhake John H · Washington, CTBuilt 1973 · S/N 310Q0844N66DHKingsbury Raymond S · Farmington, MNS/N 320E0041N66EPSpillett James Kreg · Sandy, UTBuilt 1973 · S/N 421B0520N66RAGasu LLC · Henderson, NVBuilt 1981 · S/N 340A1231N66XXSale Reported · Denton, TXSale reportedBuilt 1964 · S/N 320C0033N6701XPlewa Gary M · Hays, NCBuilt 1960 · S/N 310-0001N6709XNeches Air Inc · Silsbee, TXBuilt 1960 · S/N 310-0009N6713XSkowbo Rock G · Winchester, VABuilt 1960 · S/N 3100013N6716XEberly Steven · Euless, TXS/N 310-0016N6720XCoburn Randy J · Saint George, UTBuilt 1960 · S/N 310-0020N6724XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1960 · S/N 310-0024N6727XVan Haitsma Kelley · Fort Worth, TXS/N 310-0027N672HBValiair Ltd Co Trustee · Casper, WYBuilt 1977 · S/N 340A0324N6731XThree One X-Ray LLC · Lebanon, OHBuilt 1960 · S/N 310-0031N6734TTravel Guys Ltd · Sparks, NVS/N 39034N6735XLocal Flight Adventures LLC · Morgantown, WVBuilt 1960 · S/N 310-0035N6739XIntravaia Anthony J · Saint Louis, MOS/N 310-0039
Back to AD 87-21-02 R1