OpenAirDocs.org
AD 2002-10-13

Registered aircraft · 562

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

N157JTWest Pacific Air LLC · Spokane, WABuilt 1982 · S/N P-589N157NNewsome Jeffrey S · Blackwell, OKBuilt 1976 · S/N TJ-52N158KSBowerman Marvin · Montgomery, TXBuilt 1982 · S/N TJ-419N158RSRegistration Pending · Wallace, CARegistration pendingBuilt 1981 · S/N TJ-359N159ZIdaho State University · Pocatello, IDBuilt 1978 · S/N TJ-178N15FMErda LLC · Wilmington, DEBuilt 1979 · S/N P-522N15JUC&D Aviation LLC · Appleton, WIBuilt 1982 · S/N TJ-434N15SYGoldman Richard D · Litchfield Park, AZBuilt 1969 · S/N P-46N15TDRegistration Pending · Chicago, ILRegistration pendingBuilt 1973 · S/N P-232N15XLrb Aviation LLC · Catawba, NCBuilt 1979 · S/N TJ-226N160CRBas Part Sales LLC · Greeley, COBuilt 1968 · S/N P-24N161ABSafford Aviation Service Inc · Coolidge, AZBuilt 1977 · S/N TJ-122N162DFFaford Aviation Leasing Co · Atherton, CABuilt 1982 · S/N TJ-403N1642WFreeport Supply Co · Wyandotte, MIBuilt 1972 · S/N P-198N167UDodson International Parts Inc · Rantoul, KSS/N P-99N168SPMadura Mark · Anchorage, AKBuilt 1980 · S/N P-553N16GKMachugh Adam S · Pasco, WABuilt 1970 · S/N P144N1717SXp Silva Air LLC · Rockaway, NJS/N TJ-53N171DFDkg Motorized Conveyances Inc · Beaverton, ORBuilt 1978 · S/N TJ-155N177DGHesperia Construction Inc DBA · Ramona, CABuilt 1979 · S/N TJ-241N178BGSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 1978 · S/N P-459N17ESCrimson Aviation LLC · New York, NYBuilt 1985 · S/N TJ-488N17GPRed River Partners LLC · Edmond, OKBuilt 1979 · S/N TJ-210N17TKTucker John F · Sheridan, WYBuilt 1978 · S/N P-480N1806DGold Coast Logistics LLC · St Simons Island, GABuilt 1981 · S/N TJ-364N1808RFlorida Fence Corp · Tavernier, FLS/N TJ-366N1808SPowell Avionics Inc · Fayetteville, NCBuilt 1981 · S/N P-573N1808WSailaway Management Inc · Wilmington, DEBuilt 1973 · S/N P-215N1815LEagles Rise Aviation LLC · Wales, MAS/N TJ-63N1817ZOrr Lynn E · Fredericksburg, OHBuilt 1981 · S/N TJ-386N181BDQualitair LLC · MichelstadtS/N P-563N181JRCavu Clearing LLC · Palm Coast, FLBuilt 1982 · S/N TJ-363N18245N18245 Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1977 · S/N P-429N18280Team Holdings Inc · Sheridan, WYBuilt 1977 · S/N TJ-112N1828LTye Boys LLC · Tulia, TXBuilt 1976 · S/N P-385N1830ZJaju Aviation Inc · Abilene, TXBuilt 1981 · S/N TJ-379N18400Cohen Ralph S · Marietta, GABuilt 1977 · S/N P-412N1843LRegistered aircraftS/N TJ-65N1858PBaron N1858p LLC · Fresno, CABuilt 1981 · S/N TJ-372N1873WDuke Aerospace LLC · Shelbyville, KYBuilt 1973 · S/N P-231N1883LAirflo LLC · Wilmington, DEBuilt 1976 · S/N P-383N1887LEllin Roger E Jr · Naples, FLBuilt 1976 · S/N P-388N188BHJetspeed Solutions LLC · Middletown, DEBuilt 1980 · S/N P-526N188WW3l0 Air LLC · Chuluota, FLBuilt 1976 · S/N TJ-67N18SCSpencer Clyde V · Queen Creek, AZBuilt 1977 · S/N TJ-111N18VJAssurance Data Inc · Indiana, PABuilt 1984 · S/N TJ-445N195SDN195sd LLC · Senatobia, MSBuilt 1979 · S/N P-494N199PBSkyflite LLC · Hillsboro, ORS/N TJ-137N19BLEthereal Wings LLC · Tucson, AZS/N P-267N19ESRegistered aircraftBuilt 1980 · S/N TJ-296
Back to AD 2002-10-13