AD 90-02-13

Registered aircraft · 3,863

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:90-02-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-02-13')
  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.

N241TSGrey Matter Inc · Valley Springs, CAS/N 421B0110N242GDodson International Parts Inc · Rantoul, KSS/N 340A0799N242HB2hb Airways LLC · Saint Louis, MOBuilt 1970 · S/N 421B0049N242KABig River Air LLC · Jackson, MSBuilt 1983 · S/N 340A1802N245BMBen-Hur Air Chariots LLC · Fort Myers, FLBuilt 1971 · S/N 310Q0411N245JKSpruce Hill Leasing LLC · Hadley, MAS/N 414A0613N245THigh Country Aero Ltd · Berthoud, COS/N 421C1104N246BGuynn Dane L · Peachtree City, GAS/N 310K0030N246BEOn Top Aviation LLC · North Las Vegas, NVBuilt 1976 · S/N 414-0841N246JWPierson Janice R Trustee · Scio, ORBuilt 1981 · S/N 340A1253N246KAStahl Richard J · Gainesville, TXBuilt 1984 · S/N 340A1817N247CTConsolidated Technologies · Woodbury, MNBuilt 1961 · S/N 320-0058N247EFNobles Vernon H Jr · Calabasas, CABuilt 1968 · S/N 310P0023N247GSHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0637N24CFAmerica Aviation LLC · Yuma, AZBuilt 1979 · S/N 340A0659N24GBSmith Loren · Great Falls, MTS/N 421C0287N24KMNorthern Jet Inc · Iron Mountain, MIS/N 310Q0631N24PMHaven Harmony LLC · Sheridan, WYBuilt 1973 · S/N 310Q0705N24SLSkye Tess Airlines LLC · Holmdel, NJBuilt 1980 · S/N 414A0610N251JLGolden Eagle 421 LLC · Alsip, ILBuilt 1977 · S/N 421C0311N251WWEbbert Thomas E DBA · Gary, INRegistration revokedBuilt 1967 · S/N 411-0251N252DLPlac Holdings LLC · Paradise, TXBuilt 1975 · S/N 310R0242N252SLone Peak Air LLC · Gillette, WYBuilt 1980 · S/N 340A0984N254CMGatewood Crisp · Tifton, GABuilt 1975 · S/N 310R0254N254PBNicole Business Group LLC · Hooks, TXBuilt 1982 · S/N 340A1504N254TM56h LLC · St Simons Island, GABuilt 1979 · S/N 414A0254N255AOld Aircraft Inc · Lake City, FLBuilt 1956 · S/N 35285N255MBPhoenix Aircraft Management LLC · Marathon, FLFirst renewal noticeBuilt 1968 · S/N 310N-0110N256CAHyannis Air Service Inc · Hyannis, MAS/N 402C0606N257JDAntonini Vittorio · New York, NYBuilt 1970 · S/N 310Q-0071N258PBHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0336N25EBLeisurecorp Inc · Anchorage, AKBuilt 1976 · S/N 340A0043N25EWBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 310K0063N25FERound Trip Lc · Elkhart, KSS/N 421-0055N25LPBer Aviation Inc · Saratoga, CABuilt 1973 · S/N 310Q0748N25RFMlf Aviation LLC · Douglasville, GABuilt 1973 · S/N 340-0307N25TAJms Properties Inc · Hudsonville, MIBuilt 1982 · S/N 340A1538N2602CRrb Aviation LLC · Jasper, TXBuilt 1954 · S/N 35002N260RAUpward Aviation LLC · Tulsa, OKBuilt 1980 · S/N 421C1004N2610CNelson Scott J · Saline, MIBuilt 1954 · S/N 35010N2610GBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 402C0064N2611XHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0072N2614LCharter Flights Caribbean Inc · San Juan, PRBuilt 1979 · S/N 402C0092N26156Hyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0112N2615GHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0101N2615QVenture Air Solutions Inc · Opa Locka, FLBuilt 1980 · S/N 402C-0321N2617NFlightcentrx LLC · Peachtree City, GAS/N 414A0273N2618LFl & J Air Corp · West Orange, NJBuilt 1979 · S/N 414A0284N2618VPlatz James · Auburn, MES/N 414A0285N2619GDodson International Parts Inc · Rantoul, KSFirst renewal noticeS/N 414A0290
Back to AD 90-02-13