AD 2001-12-01

Registered aircraft · 1,309

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:2001-12-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-12-01')
  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.

N2316XJnj Aviation Inc · Wilmington, DEBuilt 2010 · S/N 4636487N231CMQet Aircraft Services LLC · Rancho Viejo, TXBuilt 2002 · S/N 4697146N2325DBeck Sod Farm Inc · Palms, MIBuilt 2008 · S/N 4697339N2325JLesterville Land Holdings LLC · Ellington, MOBuilt 2010 · S/N 4636480N234AGLop LLC · Orangeburg, SCBuilt 2011 · S/N 4636510N234PMDiamond Enterprises LLC · Lincoln, NEBuilt 2005 · S/N 4697200N235TWSalcedo Enrique · San Diego, CABuilt 2003 · S/N 4697157N2365SIe3 Enterprise LLC · Elk Grove, CABuilt 2011 · S/N 4636490N2369AValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 4636851N237CLnh Holdings LLC · Richardson, TXBuilt 2013 · S/N 4636610N237JMBrekke Aviation Inc · Edmore, NDBuilt 2001 · S/N 4697078N237MAR E Dimond And Associates Inc · Indianapolis, INBuilt 2013 · S/N 4636587N237STIlluminus Aviation LLC · Chicago, ILBuilt 2005 · S/N 4697237N23DKStockwell Aviation LLC · Clarence Center, NYBuilt 2018 · S/N 4636721N2406PAam Aeromed LLC · Wilmington, DEBuilt 2011 · S/N 4697448N240ERAlexander Aviation LLC · Scottsdale, AZBuilt 2011 · S/N 4697447N2413ACotner Jeffry J · Houston, TXBuilt 2011 · S/N 4636496N2418WSierra Tango Air LLC · Sycamore, ILBuilt 2011 · S/N 4697464N241DGJust Plane Fun · Santa Barbara, CABuilt 2010 · S/N 4636489N241PMBryants Aviation Inc · Batesville, ARBuilt 2003 · S/N 4697150N2424UOregon Air Classics LLC · Fife, WABuilt 2011 · S/N 4697459N242MJWch/Lgs Sky Ventures LLC · Littleton, NCS/N 4636674N242WFN242wf LLC · Wilmington, DEBuilt 2012 · S/N 4636571N244DFPapa 46 Ventures LLC · Ellenton, FLBuilt 2010 · S/N 4697445N244LMSunset Horizons LLC · Clovis, CABuilt 2012 · S/N 4636531N245EABlue Heron Aviation LLC · Port Orange, FLBuilt 2021 · S/N 4636777N245SSharpaire LLC · Wilmington, DEBuilt 1997 · S/N 4636104N246LRegistered aircraftBuilt 2023 · S/N 4636825N247TJNicholas Sol · Colorado Springs, COBuilt 2014 · S/N 4697561N248DAJb Air Services LLC · Brighton, COBuilt 2003 · S/N 4697156N249FBK4m Aviation LLC · Marksville, LABuilt 1999 · S/N 4636221N250BTHeart Gate Enterprises LLC · Pittsburgh, PABuilt 2002 · S/N 4636334N250DFDmfs Leasing LLC · Des Moines, IABuilt 2026 · S/N 4636878N250SAAircraft Partner Holdings Inc Trustee · BerlinBuilt 2000 · S/N 46-97004N25120Waconda Concepts LLC · Sturgis, SDBuilt 1985 · S/N 46-8508097N2519FAmerican Aviation Inc · Brooksville, FLBuilt 2012 · S/N 4697494N2529XCpdl Pm LLC · Dallas, TXBuilt 2012 · S/N 4636553N252CValiair Lc Trustee · Casper, WYBuilt 2012 · S/N 4697498N252MJThorpe Curtis D · Fredericksburg, TXBuilt 2012 · S/N 4636548N25324Central Valley Air LLC · Logan, UTBuilt 2013 · S/N 4697519N253HLIscil Kaan · Miami, FLBuilt 2021 · S/N 4636779N253MAHoosier Doc LLC · South Bend, INFirst renewal noticeBuilt 2004 · S/N 4636353N2545HNoble Aviation Enterprises LLC · Phoenix, AZBuilt 2012 · S/N 4636561N254HTFly254 LLC · Waco, TXBuilt 1993 · S/N 4622127N255DWHales Gutter Guys LLC · Sedona, AZBuilt 2000 · S/N 4697020N255RZIsr Aviation LLC · Wilmington, DES/N 4697504N2569YDavidson James E · Bothell, WAS/N 46-8508104N257LGClear Sky Aviation LLC · Coral Springs, FLS/N 46-36066N25906Valiair Limited Co Trustee · Casper, WYBuilt 2013 · S/N 4636590N2590UBlue & Gold LLC · South Boston, VABuilt 2013 · S/N 4697514
Back to AD 2001-12-01