AD 2002-01-09

Registered aircraft · 439

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-09')
    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-09')
  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.

N71TPNortheast Montana Stat Air Ambulance Cooperative · Glasgow, MTBuilt 2000 · S/N 371N723KPKalinin Partners LLC · Juneau, AKBuilt 1999 · S/N 296N724HFAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 564N724KPKalinin Partners LLC · Juneau, AKBuilt 2000 · S/N 361N725KPKalinin Partners LLC · Juneau, AKBuilt 2001 · S/N 429N726KPKalinin Partners LLC · Juneau, AKBuilt 2001 · S/N 400N728MGKnot Crazy Horse LLC · Thonotosassa, FLBuilt 2005 · S/N 607N72AZBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 495N732SBAero Shares LLC · Excelsior, MNBuilt 2001 · S/N 410N755EMSea Star Inc · Wetumpka, ALBuilt 2005 · S/N 661N766DLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2004 · S/N 601N76XCHangar C-403 LLC · Walnut Creek, CABuilt 1985 · S/N 485N770FLTailwinds Aviation LLC · Wilmington, DEBuilt 2003 · S/N 501N771WBAir Bus LLC · Dickinson, NDS/N 240N774DKOrr Franklin M Jr Trustee · Stanford, CABuilt 1996 · S/N 167N776JTBoutique Air Inc · Dallas, TXBuilt 2004 · S/N 563N77ZAAngel Lou Aviation LLC · Gilford, NHBuilt 1999 · S/N 300N77ZEPmc Distribution Inc · Keswick, VABuilt 2000 · S/N 340N781DLRice Flying LLC · Poplar Bluff, MOBuilt 2000 · S/N 334N78PGLance Toland Ltd · Wilmington, DEBuilt 2000 · S/N 370N795MKSouthern Palms Leasing LLC · Sarasota, FLBuilt 1985 · S/N 487N798WCLonely Butte Management LLC · St George, UTBuilt 2005 · S/N 613N79CSFord Gt Holdings LLC · Fort Dodge, IABuilt 1995 · S/N 125N7YRBoutique Air Inc · Dallas, TXS/N 532N7ZTZia Air LLC · Redwood City, CABuilt 2001 · S/N 385N802HSSecurity Holdings LLC · Richmond, VABuilt 1995 · S/N 118N807JHClark Joseph · Seattle, WABuilt 1985 · S/N 498N810VJVee Jay Equipment (De) LLC · Clarkston, MIBuilt 2005 · S/N 610N811VMGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N 316N812PAPriority Air Charter LLC · Kidron, OHBuilt 1994 · S/N 106N814PAPriority Air Charter LLC · Kidron, OHBuilt 1994 · S/N 110N816BPAls Aviation LLC · Westlake Village, CABuilt 1985 · S/N 480N817WAWarner Alan/N-Leasing LLC · Fort Worth, TXBuilt 1996 · S/N 137N818RAWanderlust Air LLC · Fort Lauderdale, FLBuilt 1997 · S/N 179N828PCSbma Services LLC · Mcclellan, CAS/N 479N828RXN828rx Inc Trustee · Wilmington, DEBuilt 2003 · S/N 531N832BHVahalda LLC · Bend, ORBuilt 2003 · S/N 508N8421ETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 430N84GEHighwings LLC · Fargo, NDBuilt 2001 · S/N 408N851RMLas Madronas Aviation LLC · Incline Village, NVS/N 360N852ALMetro Aviation Inc · Shreveport, LABuilt 1998 · S/N 213N853ALMetro Aviation Inc · Shreveport, LABuilt 1996 · S/N 168N854ALAir Methods LLC · Greenwood Village, COBuilt 2001 · S/N 397N861PPIrlbeckbruch Plane LLC · York, NEBuilt 2003 · S/N 510N866KMMac Aviation LLC · Fargo, NDBuilt 2003 · S/N 528N870A & S Aviation LLC · Chesterfield, MOBuilt 1993 · S/N 607N870CBRaci Management Company Inc · Ogden, UTBuilt 2005 · S/N 657N875RJUS Air Force Special Operations Command/A5km · Hurlburt Field, FLS/N 646N87CBClayton Boyd Agricultural Equipment LLC · Valley View, TXBuilt 2005 · S/N 681N888GWSouthland Sod Farms Operations Inc · Oxnard, CABuilt 2001 · S/N 421
Back to AD 2002-01-09