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.

N121MACisnero Francisco Javier Picazo · Mckinney, TXBuilt 2009 · S/N 4697406N121NSPorto Mark · Wilmington, DEBuilt 2007 · S/N 4697292N121REHigh Life Aviation LLC · St George, UTBuilt 2017 · S/N 4636718N121TRRay Timothy E · Fort Walton Beach, FLBuilt 2019 · S/N 4697669N1228Hodges Farms LLC · Grain Valley, MOBuilt 1987 · S/N 4608092N122WDSazerac Air LLC · Bedford, NHBuilt 1997 · S/N 4636084N123TEVirgil W Young Jr Pa · North Little Rock, ARBuilt 1994 · S/N 4622169N123TSRyen Air LLC · Wilmington, DEBuilt 2005 · S/N 4697219N124CCWeaks Taylor Madison · Houma, LABuilt 1984 · S/N 46-8408036N124EDSecond Wind Enterprises LLC · Chamblee, GABuilt 2014 · S/N 4636642N1258QSiner John R · Kingsport, TNBuilt 1999 · S/N 4636191N126STNextgen Flyers LLC · Ephrata, PABuilt 2011 · S/N 4697465N127CBird Brian A · Duluth, MNBuilt 2013 · S/N 4636604N128CTaylor Chevrolet Co · Rexburg, IDBuilt 2013 · S/N 4697528N128EDSimply Living LLC · Fort Myers, FLBuilt 2000 · S/N 4636258N129EJShelbyville Auto Sales LLC · Shelbyville, TNBuilt 2001 · S/N 4697065N12EVDaedalus LLC · Little Rock, ARBuilt 1985 · S/N 46-8508065N12KWAllied Moulded Products Inc · Bryan, OHBuilt 2000 · S/N 4636255N130URegistered aircraftFirst renewal noticeBuilt 2018 · S/N 4697644N131RLLeads Air Inc · Dover, DEBuilt 1989 · S/N 4622048N132LTCobblestone Capital Aviation LLC · Sylacauga, ALBuilt 2011 · S/N 4636493N133KBIsland Time Aviation LLC · Peachtree City, GABuilt 1996 · S/N 4636049N133PKFinn And Conway Inc · Bridgeview, ILBuilt 2004 · S/N 4697196N133SRBas Part Sales LLC · Greeley, COBuilt 2001 · S/N 4697114N133WCRegistration Pending · Huntingdon, TNRegistration pendingBuilt 2000 · S/N 4636251N134ME D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2003 · S/N 4697169N135FLAfdflt LLC · Mount Vernon, ILBuilt 2002 · S/N 4697135N135JMBill White Transportation LLC · Poteau, OKS/N 4697072N135USJohn Hale · Temple, TXBuilt 1987 · S/N 46-08078N137KMAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2001 · S/N 4697091N138CMMam Consulting LLC · Keller, TXBuilt 2014 · S/N 4697579N138YNw Ventures LLC · Palo Alto, CAS/N 4697505N139LFLgd Properties Inc · Wylie, TXBuilt 2011 · S/N 4636505N13PCGj Aviation LLC · Mountain Lakes, NJBuilt 1984 · S/N 46-8408081N141SBCk Aviation LLC · Bismarck, NDBuilt 1999 · S/N 4636244N142EEHound Dog Aircraft LLC · Lawrence, KSBuilt 2005 · S/N 4697217N1438TFreedom Flyers II LLC · Islip, NYBuilt 2014 · S/N 4636615N143LAMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2009 · S/N 4636459N143PPBolch James R · Vero Beach, FLBuilt 2015 · S/N 4636664N146BUSaltwater Aviation LLC · Friday Harbor, WABuilt 1984 · S/N 46-8408057N146MSMagnolia Partners Aviation LLC · Lockesburg, ARBuilt 1984 · S/N 46-8408032N146NCHills Jason · Bothell, WABuilt 1998 · S/N 4636176N146RFValiair Limited Co Trustee · Casper, WYBuilt 2011 · S/N 4636502N146ZFNo Boundry Airplane LLC · Council Bluffs, IABuilt 1984 · S/N 46-8408002N14BCSrdo Advanced Wound Care Associates Pllc · Dallas, TXS/N 4636014N14CXVortac LLC · Traverse City, MIBuilt 1988 · S/N 4608107N14EFInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N 4622009N14GVScott T LLC · Portland, ORS/N 4697092N14PCAlooment LLC · Las Vegas, NVBuilt 1989 · S/N 4622027N151TMBehel Bobby O · Tuscumbia, ALBuilt 2010 · S/N 4636467
Back to AD 2001-12-01