OpenAirDocs.org
AD 87-12-02

Registered aircraft · 43

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-12-02')
    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-12-02')
  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.

N100KEPm Leasing Inc · Perris, CABuilt 1974 · S/N 313SAN11SJSouthland Metroplex Aviation LLC · Colleyville, TXBuilt 1973 · S/N 285N129DWDelta Whiskey Ltd · Staten Island, NYBuilt 1974 · S/N 653N143JACosco & Associates Inc · Crestview, FLBuilt 1974 · S/N 324N165MARegistered aircraftBuilt 1975 · S/N 326N216CDLandry Camile J · Baton Rouge, LABuilt 1974 · S/N 323N261WBNorthern Jet Sales LLC · Port Saint Lucie, FLBuilt 1975 · S/N 330N272MCN272mc Leasing LLC · South Jordan, UTBuilt 1973 · S/N 272N281MAWife Approved LLC · Torrance, CABuilt 1973 · S/N 261N28AFEumundi Trading Co Inc · Wilmington, DES/N 241N305DSAircraft Operations LLC · Portland, ORBuilt 1975 · S/N 328N316ENFayetteville Aviation Inc · Fayetteville, TNBuilt 1976 · S/N 349SAN324GMSycan Corp DBA · Paso Robles, CABuilt 1974 · S/N 310N325MASouthern Aviation LLC · Durham, NCBuilt 1974 · S/N 325N375ACCelco Constantine Eng Lab Co · Wilmington, DEBuilt 1975 · S/N 327N383TXPositive Rate LLC · Eatonton, GABuilt 1975 · S/N 332N3GTR&G Aircraft LLC · Zeeland, MIS/N 277N40KCAir 1st Aviation Companies Inc · Glendale, AZBuilt 1974 · S/N 322N450FSRaju Leasing Co LLC · Jackson, MSBuilt 1976 · S/N 338N461MAGood Aviation LLC · Oshkosh, WIBuilt 1974 · S/N 301N462MARegistered aircraftBuilt 1974 · S/N 302N480AFAir 1st Aviation Companies Inc · Aiken, SCS/N 248N481AFAir 1st Aviation Companies Inc · Tyndall Afb, FLS/N 253N482AFAir 1st Aviation Companies Inc · Tyndall Afb, FLS/N 265N483AFAir 1st Aviation Companies Inc · Aiken, SCBuilt 1973 · S/N 271N485AFLaver Michael · Glendale, AZBuilt 1974 · S/N 308N486AFAir 1st Inc · Tyndall Afb, FLBuilt 1975 · S/N 329N487AFAir 1st Aviation Companies Inc · Tyndall Afb, FLBuilt 1975 · S/N 333N489AFLaver Michael · Glendale, AZS/N 243N507ZZAce Aviation LLC · Mankato, MNS/N 264N50AFWyoming Aeroflight LLC · Laramie, WYS/N 286N50ETRegistered aircraftBuilt 1973 · S/N 260N50KSedghi Reza · Macon, GABuilt 1974 · S/N 305N54PCAxel Neil Jeffery · Portland, ORBuilt 1974 · S/N 319N601SDNorthern Jet Sales LLC · Port Saint Lucie, FLBuilt 1973 · S/N 610N616KLFraser Peter · Powell Butte, ORBuilt 1973 · S/N 267N621TAAustin Bill DBA · Sparta, TNS/N 605N64LGRed Star Aero Services LLC · Mobile, ALBuilt 1972 · S/N 240N728FNAustin Bill DBA · Sparta, TNS/N 303N800EDClassic Aircraft Sales LLC · Wilmington, DES/N 339N892SCDrs Sandra M Krokos And Thomas P Kislan Pc · Drums, PABuilt 1979 · S/N 392 S.A.N910NFAir 1st Aviation Companies Of Oklahoma Inc · Tulsa, OKBuilt 1973 · S/N 623N99SRAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1974 · S/N 315
Back to AD 87-12-02