OpenAirDocs.org
AD 2002-15-02

Registered aircraft · 60

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:2002-15-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:2002-15-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.

N109BGAviation Leasing Group Inc · Wilmington, DEBuilt 1982 · S/N NA0310N109SBSabre Direct · Chicago, ILS/N 380-20N10TNPacific Rim Management LLC · Downey, CAS/N 257085N118CDFirst Aviation Service Corp · Wilmington, DEBuilt 1977 · S/N NA0212N11LXN492a LLC · Goodyear, AZBuilt 1974 · S/N 306-75N141AELake Superior College · Duluth, MNBuilt 1981 · S/N NA0306N141SLInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 306-141N179CJIal Corp · Lewes, DES/N 176N184WWRoyal Air Freight Inc · Waterford, MIBuilt 1976 · S/N 352N189RBDodson International Parts Inc · Rantoul, KSBuilt 1972 · S/N 262N18CCTamcar Aviation LLC · Kennewick, WAS/N NA0222N200FJAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1980 · S/N 408N200WKSkyview LLC · Wilmington, DEBuilt 1976 · S/N 261N201BRSky Bus Inc · North Miami Beach, FLBuilt 1968 · S/N 166N205DJDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 399N212XXLegacy Aviation Trust Holdings Corp · Edmond, OKS/N 257093N237CHBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N MJ003N238CHBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N MJ005N239CDRoyal Air Freight Inc · Waterford, MIBuilt 1975 · S/N 339N239CHColumbia Helicopters Inc · Aurora, ORBuilt 1981 · S/N MJ006N242CHColumbia Helicopters Inc · Aurora, ORBuilt 1983 · S/N MJ023N245CHColumbia Helicopters Inc · Aurora, ORBuilt 1983 · S/N MJ022N249CHColumbia Helicopters Inc · Aurora, ORS/N MM821N26MEJ Jets Inc · Los Angeles, CABuilt 1982 · S/N NA 0315N2787Valiair Lc Trustee · Casper, WYBuilt 1984 · S/N 257208N311RSKen Sale Resources Inc · Southlake, TXBuilt 1977 · S/N 5222N33JWBj Aviation LLC · Beaver Meadows, PABuilt 1974 · S/N 306-92N378DNational Test Pilot School · Mojave, CABuilt 1975 · S/N 306-101N380CJSkyview LLC · Wilmington, DES/N 380N39CBRedstar Air Shows Inc · Discovery Bay, CABuilt 1976 · S/N 306-116N404HRBudget Jet LLC · Delray Beach, FLBuilt 1985 · S/N 455N424RTechnical Education Services Inc · Virginia Beach, VABuilt 1974 · S/N 380-15N438SJKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N 438N45KGAircraft Holding Solutions LLC · Newark, DEBuilt 1980 · S/N 257189N48DDRedstar Air Shows Inc · Discovery Bay, CABuilt 1979 · S/N 306146N511FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 122N518RRMidas Air Corp · Wilmington, DES/N NA0278N520AWGg Flight LLC · Findlay, OHBuilt 1981 · S/N 453N531FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 113N561PSTlc Aviation LLC · Bloomfield Hills, MIBuilt 1980 · S/N NA-0262N564BRKaleidoscope Charter Services Corp · Kansas City, MOS/N NA0287N600CDKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N 377N600RARoyal Air Freight Inc · Waterford, MIBuilt 1984 · S/N 296N604PTR3hd Air LLC · Marietta, GABuilt 1969 · S/N 202N607CFRedstar Air Shows Inc · Discovery Bay, CABuilt 1976 · S/N 306-118N700RMFlying Piggs LLC · Klamath Falls, ORS/N 5224N700RRDaxen Logistic LLC · Chino, CABuilt 1978 · S/N NA-0217N704FUK&A Advisors LLC Trustee · Wilmington, DES/N NA0335N710RMFlying Piggs LLC · Klamath Falls, ORBuilt 1977 · S/N 5213N725MKKen Sale Resources Inc · Southlake, TXBuilt 1968 · S/N 5123
Back to AD 2002-15-02