OpenAirDocs.org
AD 2002-01-26

Registered aircraft · 109

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.

N110JDChandler Air LLC · Bossier City, LABuilt 1984 · S/N 414N1125AAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1990 · S/N 051N112EMRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1988 · S/N 023N118RJDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 188N123EGButler Brian S · Oklahoma City, OKS/N 306N123RCBwa Westwind 2 LLC · Orlando, FLS/N 349N127PTN325nw LLC · Lodi, OHBuilt 1981 · S/N 337N13ADN13ad LLC · Dover, DES/N 030N150EXDodson International Parts Inc · Rantoul, KSS/N 262N15BADodson International Parts Inc · Rantoul, KSS/N 020N166RLLm Aeropsace Corp · Deerfield Beach, FLBuilt 1990 · S/N 047N1900ABank Of Utah Trustee · Salt Lake City, UTS/N 26N1KTEkfj LLC · Waco, TXBuilt 1978 · S/N 230N20YLAstracc LLC · Corpus Christi, TXS/N 076N2150HCove Pointe Air LLC · Adrian, MIBuilt 1977 · S/N 210N21HRJetsteam Aviation Inc · Cheyenne, WYRegistration ineffective or invalidBuilt 1981 · S/N 335N224GFShamrock Kelly Energy Inc · Blanco, TXS/N 402N229DN229d LLC · Stuart, FLBuilt 1985 · S/N 427N238DBLewis University · Romeoville, ILBuilt 1977 · S/N 215N241CTAvalair Aircraft Management LLC · Brookshire, TXBuilt 1981 · S/N 355N26BDArkansas Bolt Co · Little Rock, ARBuilt 1992 · S/N 062N26TNAj Air LLC · Blackwell, OKS/N 418N270LCMcnutt Air Partners LLC · Corsicana, TXBuilt 1979 · S/N 245N27TZSparrow Aircorp Inc · Dover, DEBuilt 1977 · S/N 213N293PWatkins Air LLC · Mountain Brk, ALBuilt 1990 · S/N 049N299FLAircraft Solutions LLC · Fredonia, WIS/N 435N29CLJordan Air LLC · Fort Smith, ARBuilt 1984 · S/N 404N29LNLucky29 Liquors LLC · Loveland, COS/N 389N29NBPpp Aviation LLC · Dover, DES/N 13N300TCOrlando Financial Corp · Bear, DEBuilt 1978 · S/N 241N300XL1911 Partners LLC · Rockledge, FLBuilt 1979 · S/N 276N30MRBergen Food Enterprises Inc · Norman, OKBuilt 1978 · S/N 225N30TKGravitas Aero LLC · Dallas, TXBuilt 1982 · S/N 374N316TDBas Part Sales LLC · Greeley, COBuilt 1980 · S/N 312N317JSWest Air LLC · Little Rock, ARS/N 385N320MDIsland Jet Aviation Inc · Lewes, DENon-citizen corporation, flight hours not reportedBuilt 1981 · S/N 366N328PCSn 328 Corp · Fort Lauderdale, FLS/N 328N331SKD & E Aviation LLC · Missoula, MTBuilt 1992 · S/N 063N33TWPolytech Adult Education · Woodside, DES/N 316N345TRJog068 Inc · Lewes, DEBuilt 1981 · S/N 345N347GAJp Flying LLC · Dover, DEBuilt 1981 · S/N 347N367WWVmrfalcon50 LLC · Evans, GAS/N 367N386RLKc Aviation Holdings LLC · Tonopah, NVS/N 386N388WA2029 Aircraft Trust 2 LLC Trustee · Davie, FLS/N 27N388WWCwj Aviation LLC · Raleigh, NCBuilt 1983 · S/N 388N3LHSilverstar Partners LLC · Houston, TXS/N 037N400GPIcmc Idaho LLC · Salinas, CAS/N 423N406HRDodson International Parts Inc · Rantoul, KSS/N 324N418WABorgne Enterprises LLC · New Orleans, LABuilt 1979 · S/N 250N419MKAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1993 · S/N 066
Back to AD 2002-01-26