OpenAirDocs.org
AD 2002-01-26

Registered aircraft · 108

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-01-26')
    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-01-26')
  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.

N430PTN430pt LLC · Chino, CABuilt 1985 · S/N 430N437SJBank Of Utah Trustee · Salt Lake City, UTBuilt 1986 · S/N 437N448GRVenti Air Service Inc · Coral Gables, FLBuilt 1993 · S/N 070N481NSJp Flying LLC · Dover, DEBuilt 1982 · S/N 378N49CTJog001inc · Lewes, DES/N 314N49MNAlliance Air Parts Acquisitions Corp · Oklahoma City, OKS/N 019N500BJAir Metro Leasing Inc · Wilmington, DEBuilt 1978 · S/N 242N528RRXavier Air LLC · Lakeland, FLBuilt 1990 · S/N 042N530DLTaylor Aero LLC · Lewes, DES/N 287N541RLBj Aviation LLC · Anchorage, AKBuilt 1989 · S/N 034N542WCHmv Aviation LLC · Elizabethton, TNBuilt 1990 · S/N 044N55FGWestwind Air LLC · Canton, GABuilt 1979 · S/N 267N565KEAviation Company Inc · Cheyenne, WYBuilt 1987 · S/N 17N56DHMetro Builders Supply Inc · Tulsa, OKBuilt 1990 · S/N 045N576PVHamilton Victor · Jupiter, FLBuilt 1982 · S/N 383N577ANFifteen Seventy Aviation LLC · Greenville, TXS/N 060N600KEJuliet Zulu Aviation LLC · Loganville, GABuilt 1985 · S/N 416N600NYNxjets.Net LLC · Wilmington, DEFirst renewal noticeBuilt 1978 · S/N 231N606MAN606ma LLC · Burleson, TXS/N 196N60BTReklaw Management Co · Houston, TXBuilt 1987 · S/N 432N64FSJetvue Texas LLC · Richardson, TXBuilt 1984 · S/N 417N666KLWj Of Delaware Inc · Fort Lauderdale, FLS/N 040N66VAFranco Plastering Inc · Naples, FLBuilt 1983 · S/N 375N686BCDodson International Parts Inc · Rantoul, KSS/N 039N696RQAzul Aviation Inc · Burleson, TXS/N 311N70DTJet Set Aviation LLC · Memphis, TNS/N 334N711KEN711ke LLC · Wilmington, DEBuilt 1980 · S/N 288N728TGDigital Interstate Management Inc · Keller, TXBuilt 1984 · S/N 420N730DFDunn Diehl Farms LLC · Wimauma, FLBuilt 1993 · S/N 067N772DCBest Aircraft Deals LLC · Salt Lake City, UTS/N 410N777BLBlackstone Mm Assets LLC · Beverly Hills, CABuilt 1990 · S/N 048N777HDButler Brian S · Oklahoma City, OKBuilt 1983 · S/N 397N789CARegistration Pending · Apopka, FLRegistration pendingBuilt 1994 · S/N 074N790JRTransenergie Inc · Houston, TXBuilt 1984 · S/N 424N795FMCypress Aircraft Sales LLC · Clermont, FLS/N 228N804CCPappas John · Cave Junction, ORBuilt 1980 · S/N 305N807BFSale Reported · Bishop, CASale reportedBuilt 1976 · S/N 194N816LCMarklyn Jet Parts LLC · Dallas, TXBuilt 1980 · S/N 291N845TXButler Brian S · Oklahoma City, OKBuilt 1981 · S/N 342N858WWMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1993 · S/N 064N85PTWestwind Air LLC · Oklahoma City, OKBuilt 1980 · S/N 285N881HASkywings Aviation LLC · Wilmington, DEBuilt 1996 · S/N 078N890BA818 Operations Inc · Wilmington, DES/N 301N894TWD Jm Holdings LLC · Sugar Land, TXBuilt 1981 · S/N 354N900DMMwm Air LLC · Adrian, MIBuilt 1981 · S/N 358N902AUAmafly LLC · Wilmington, DES/N 25N90AJBank Of Utah Trustee · Salt Lake City, UTBuilt 1991 · S/N 052N911GUTeam Aero LLC · Olathe, KSBuilt 1981 · S/N 343N928HRHoward Aviation LLC · San Antonio, TXBuilt 1984 · S/N 415N928JAWorld Champion Air LLC · Acworth, GABuilt 1995 · S/N 0075
Back to AD 2002-01-26