AD 87-10-01

Registered aircraft · 600

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-10-01')
    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-10-01')
  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.

N151SCScaled Composites LLC · Mojave, CABuilt 1990 · S/N 001N151SPLux Leasing LLC · Shreveport, LABuilt 1977 · S/N 501-0021N153TN153t LLC · Kalispell, MTS/N 550-0732N15CYAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 501-0152N15JHCentral Virginia Aviation Inc · Petersburg, VABuilt 1974 · S/N 500-0174N15WTJet Amigos LLC · Central Point, ORBuilt 1982 · S/N 550-0423N163JN163j LLC · Smithfield, NCBuilt 1987 · S/N S550-0122N166FAN166fa Aircraft Services LLC · Phoenix, AZBuilt 1980 · S/N 501-0166N168ESNext Generation Aviation LLC · Beloit, WIBuilt 1992 · S/N 550-0706N16NLWh Air LLC · Clearwater, FLBuilt 1977 · S/N 501-0043N16PLSolitaire Development LLC · Temecula, CABuilt 1981 · S/N 550-0265N16RPRose Aviation LLC · Sarasota, FLBuilt 1985 · S/N S5500047N16TSCypress Aircraft Sales LLC · Clemont, FLS/N 550-0030N16VGRegistered aircraftBuilt 1980 · S/N 501-0157N1717RJaaack Air LLC · Henderson, NVBuilt 1983 · S/N 501-0251N171WJN501sp LLC · Mount Airy, MDBuilt 1981 · S/N 501-0171N173AAInterstate Health Solutions LLC · Orlando, FLBuilt 1980 · S/N 550-0234N174CFTri Star Services LLC · Nashville, TNBuilt 1979 · S/N 501-0142N174DRIal Corp · Lewes, DEBuilt 1979 · S/N 550-0074N177RJL&S Enterprises LLC · Daytona Beach, FLS/N 550-0550N17LPN17lp LLC · Amarillo, TXBuilt 1985 · S/N S550-0111N181EBSportsmed Aviation LLC · Gulf Breeze, FLBuilt 1982 · S/N 550-0369N181GMid South Agricultural Products Inc · Lafayette, LAS/N S550-0006N18HCN4bzjp LLC · Asheville, NCBuilt 1981 · S/N 501-0223N18HJFanac LLC · Palestine, TXBuilt 1988 · S/N 550-0587N191TFCci Air LLC · Gary, INBuilt 1988 · S/N 550-0567N197PRGoodnights Spruce Goose LLC · Harmony, NCBuilt 1992 · S/N 550-0704N199JKWatts John · Murchison, TXBuilt 1974 · S/N 500-0199N1EJFlying Bishi LLC · North Miami, FLBuilt 1981 · S/N 501-0191N1SVJtl Leasing Co LLC · Kalispell, MTBuilt 1980 · S/N 550-0150N1TYOwens Scotty · Crofton, KYBuilt 1980 · S/N 550-0171N200CGTropic Bird Supply Inc · Hypoluxo, FLS/N 500-0230N200NCMidwest Jet LLC · Lynd, MNBuilt 1980 · S/N 550-0184N204CAGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1978 · S/N 501-0283N204CFCorporate Flight Inc · Waterford, MIBuilt 1980 · S/N 550-0238N204PMDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 550-0320N2057HCam Jet Aviation LLC · Lamesa, TXBuilt 1981 · S/N 550-0274N20YTWoodbine Aviation LLC · Lewes, DES/N 550-0213N211MTTrn Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1979 · S/N 550-0098N212MN212m LLC · Senatobia, MSBuilt 1977 · S/N 501-0280N212MRLeader Air Service Inc · Miami, FLS/N 550-0210N213JSN213js LLC · Lewes, DEBuilt 1989 · S/N 5500597N214JTBig River Air LLC · Wilmington, DEBuilt 1982 · S/N 550-0418N218JGNoel Edmund O · Houston, TXBuilt 1981 · S/N 5010218N219MSPuerto Rico Air LLC · Winter Park, FLBuilt 1980 · S/N 550-0180N21LMN21lm LLC · Dover, DES/N 560-0117N21UAAbercorn Services LLC · Wilmington, DEBuilt 1982 · S/N 550-0356N220BPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N S550-0034N225HAAircraft Fidelity Corp Trustee · Dover, DEBuilt 1979 · S/N 550-0089N229BMCessna Aircraft Leasing LLC · Daytona Beach, FLS/N 5500207
Back to AD 87-10-01