AD 2002-11-07

Registered aircraft · 1,512

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-11-07')
    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-11-07')
  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.

N1604MMckinney John Merrill Jr · Bessemer, ALBuilt 1983 · S/N TH1359N1604WSteve Byrd Aviation LLC · Terrell, TXBuilt 1972 · S/N TH-242N1619WExecutive Aircraft Management LLC · Northport, ALBuilt 1972 · S/N TE-869N161ABSafford Aviation Service Inc · Coolidge, AZBuilt 1977 · S/N TJ-122N1629WRegistered aircraftN-number assigned, not yet registeredS/N TH-245N162DFFaford Aviation Leasing Co · Atherton, CABuilt 1982 · S/N TJ-403N163SPAgriflite Services Inc · Wakarusa, INBuilt 1972 · S/N TE-872N1648WKings Aviation Corp · Garden City, NYBuilt 1972 · S/N TH-251N166BVSensing Aviation LLC · Nashville, TNBuilt 2000 · S/N TH-1958N1673WOci Ltd · Brunswick, GABuilt 1972 · S/N TH-258N167TRBarton Aviation LLC · San Antonio, TXBuilt 1998 · S/N TH-1849N168CCLanham Aviation LLC · Simpsonville, KYBuilt 1990 · S/N TH-1606N169RRGerlach & Associates LLC · Valparaiso, INBuilt 1979 · S/N TH-999N16DADonaire Aviation LLC · Tampa, FLBuilt 1974 · S/N TH-501N16PMcmurray Justin John · Durham, NCBuilt 1999 · S/N TH-1925N1717SXp Silva Air LLC · Rockaway, NJS/N TJ-53N171DFDkg Motorized Conveyances Inc · Beaverton, ORBuilt 1978 · S/N TJ-155N1748WBas Part Sales LLC · Greeley, COBuilt 1972 · S/N TE-887N174URocky Mountain Ventures Inc · Cheyenne, WYBuilt 1970 · S/N TH-73N17577James Rodney D · Bono, ARBuilt 1977 · S/N TE-1091N17604Montgomery Aviation Corp · Montgomery, ALBuilt 1977 · S/N TE-1094N17660Simpson Chad · Harrison, ARBuilt 1977 · S/N TH-810N17732Wright Brian L · Franklin, TNBuilt 1977 · S/N TE-1102N177ABKostroski Larry J · Tucson, AZBuilt 1972 · S/N TE-873N177DGHesperia Construction Inc DBA · Ramona, CABuilt 1979 · S/N TJ-241N17820Evergreen Flying Service Inc · Rayville, LABuilt 1977 · S/N TE-1101N17833Mccall Edmund B · Portland, ORBuilt 1977 · S/N TH-827N17850Copeland Kenneth E · Rosie, ARBuilt 1977 · S/N TK-58N17979Alford Flying LLC · Wichita, KSBuilt 1977 · S/N TH-832N17980Rowles Robert · Pittsfield, ILBuilt 1977 · S/N TH-840N17BRJds Management Co LLC · Warner Robins, GABuilt 1983 · S/N TH-1372N17ESCrimson Aviation LLC · New York, NYBuilt 1985 · S/N TJ-488N17GPRed River Partners LLC · Edmond, OKBuilt 1979 · S/N TJ-210N1804WWillis Jerry · Jackson, MIBuilt 1972 · S/N TE-893N1806DGold Coast Logistics LLC · St Simons Island, GABuilt 1981 · S/N TJ-364N1807NDouble Barrel Aviation LLC · Fort Valley, GABuilt 1981 · S/N TH-1263N1808RFlorida Fence Corp · Tavernier, FLS/N TJ-366N1810XAviation Trust Company LLC Trustee · Oklahoma City, OKS/N TH1266N1812WBolin Steven D · Odessa, TXBuilt 1972 · S/N TE-894N18142Aviation Trust Co LLC · Oklahoma City, OKBuilt 1981 · S/N TH-1270N1815LEagles Rise Aviation LLC · Wales, MAS/N TJ-63N1817SClear Skies LLC · Stuart, FLBuilt 1981 · S/N TH-1271N1817ZOrr Lynn E · Fredericksburg, OHBuilt 1981 · S/N TJ-386N181JRCavu Clearing LLC · Palm Coast, FLBuilt 1982 · S/N TJ-363N1827LCone James R Jr · Lubbock, TXS/N TH-741N18280Team Holdings Inc · Sheridan, WYBuilt 1977 · S/N TJ-112N18296Star Flight Aviation Inc · Shreveport, LABuilt 1977 · S/N TH-844N1829ECorporate Airtime LLC · Clinton, MSBuilt 1981 · S/N TH-1282N1830ZJaju Aviation Inc · Abilene, TXBuilt 1981 · S/N TJ-379N18320Cox Jack H Jr · Arlington, TXBuilt 1977 · S/N TH-849
Back to AD 2002-11-07