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.

N152ALN152al LLC · Tulsa, OKBuilt 2004 · S/N 4697182N152WFMcmanus Russel · Chicago, ILBuilt 2001 · S/N 4697035N153TCCroley Equipment Leasing LLC · Ocala, FLBuilt 2007 · S/N 4697307N154DRN154dr LLC · Brush, COS/N 4697034N155MAOne Zero Three Six Papa LLC · Florence, SCBuilt 2019 · S/N 4636743N15EFEastern Aviation Fuels Inc · New Bern, NCBuilt 1999 · S/N 4636195N15FKOctagon Air LLC · Windham, MEBuilt 2011 · S/N 4697469N15SASkytrain LLC · Markle, INBuilt 2015 · S/N 4697599N15XJSt Express LLC · El Segundo, CABuilt 2022 · S/N 4636796N1630WN O Good LLC · Wade, NCBuilt 2011 · S/N 4636508N168GFC2c LLC · Christiansted, VIS/N 4636189N168RVAkn Enterprises LLC · Springfield, MOBuilt 2006 · S/N 4697252N16LTClausen Frederik M · Lake Forest, ILBuilt 1988 · S/N 4608130N170LAEducators Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4697341N171HPAlliance Diversified Enterprises Inc · Escondido, CABuilt 2008 · S/N 4697371N171MElevated Holdings Inc · Newport Beach, CABuilt 2024 · S/N 4636841N172MAN172ma LLC · Miramar Beach, FLBuilt 2006 · S/N 4697263N175MADakota Equipment LLC · Bismarck, NDBuilt 2011 · S/N 4697461N175NCapital Consulting LLC · Newport Beach, CABuilt 2008 · S/N 4697370N175WBHerdair Group LLC · Conroe, TXBuilt 2004 · S/N 4697181N176MAPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4697729N177HCQualitair LLC Trustee · MichaelstadtBuilt 2001 · S/N 4636314N177MASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1994 · S/N 4622177N178DBPrm Enterprises Inc · Manchester, NHS/N 4636333N17LHHigh Flying Investments LLC · Texarkana, ARBuilt 2000 · S/N 46-97007N17NGParmer Construction Company LLC · Terrell, TXBuilt 1987 · S/N 4608074N17PL2nd Amendment Wholesale Inc · Grand Forks, NDBuilt 2014 · S/N 4697551N181TRPk Financial Consulting LLC · Chandler, AZBuilt 2013 · S/N 4636580N184AEN184ae LLC · Ault, COBuilt 2000 · S/N 4697026N186PSRricko LLC · Portland, ORS/N 4697228N187JDMacarthur Dougald F · Littleton, NHBuilt 2004 · S/N 4697180N188CECruise Air LLC · Wilmington, DEBuilt 2005 · S/N 4697239N188KCMalibu Management LLC · Ponte Vedra, FLBuilt 2013 · S/N 4636588N188LAAvf Flyers LLC · Richmond, VAS/N 4636185N188LGMyskinmedspa LLC · Rockledge, FLBuilt 1989 · S/N 4622043N188PMCairn Vista Holdings LLC · Santa Rosa, CABuilt 2012 · S/N 4697501N189MHSpirit Life Inc · Morrison, COBuilt 1998 · S/N 4636159N18JMDixon John F · Hayden, IDBuilt 1999 · S/N 4636229N18JSAdelaar Holdings LLC · Missoula, MTBuilt 2016 · S/N 4636702N190CCWayside LLC · Wilmington, DEBuilt 1984 · S/N 46-8408045N191DBMeridian Logistics LLC · Forest Lake, MNBuilt 2005 · S/N 4697232N1921JPjet Holdings LLC · Chattanooga, TNBuilt 2013 · S/N 4636606N1937BPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 4636858N193SFBlue Castle Properties LLC · Littleton, COBuilt 2012 · S/N 4636567N194PMDye David A · Point Clear, ALBuilt 1993 · S/N 4622146N19500Wright Bros Flying Club LLC · Lewes, DEBuilt 1994 · S/N 4622163N195JGN195jg Aviation LLC · Port Republic, NJBuilt 1994 · S/N 4622173N1968WPtt Aircraft Management Inc · Newport Beach, CABuilt 2001 · S/N 4697115N1972MN1000 LLC · St Simons Island, GABuilt 2014 · S/N 4636631N1972XAds Investment Firm LLC · Pacifica, CABuilt 2012 · S/N 4636524
Back to AD 2001-12-01