OpenAirDocs.org
AD 2001-01-52 R1

Registered aircraft · 985

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-01-52-R1')
    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-01-52-R1')
  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.

N941JVParagon Air Group · Fort Worth, TXBuilt 2008 · S/N 53911N944HHillcrest Aircraft Co · Lewiston, IDS/N 53122N944TGMetro Aviation Inc · Shreveport, LABuilt 2012 · S/N 54377N945RFCharm Aviation Heli I LLC · Windham, NHBuilt 2015 · S/N 54581N947LHExecutive Air Taxi Corp · Bismarck, NDBuilt 2001 · S/N 53509N947MDAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 53569N953GMLindsey Aviation Services · Haslet, TXBuilt 2006 · S/N 53720N955TGMetro Aviation Inc · Shreveport, LABuilt 2012 · S/N 54379N956AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54597N958TRStraight Up Leasing Inc · Medford, ORBuilt 2007 · S/N 53770N959LPPanther Helicopters Inc · Belle Chasse, LABuilt 2006 · S/N 53690N95MPMissouri State Highway Patrol Aircraft Division · Jefferson City, MOS/N 56324N960GCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1998 · S/N 53237N963JSLindsey Aviation Services · Haslet, TXBuilt 2006 · S/N 53680N968GWGrady White Boats Inc · Greenville, NCBuilt 2013 · S/N 54437N96GUMg Aviation Inc · Santa Monica, CABuilt 2013 · S/N 54399N970CGm Leasing Company LLC · Broussard, LABuilt 2012 · S/N 54347N970CLQwest Corp · Broomfield, COBuilt 2013 · S/N 54414N973LNMetro Aviation Inc · Shreveport, LAS/N 54821N973MFMercy Flights Inc · Medford, ORBuilt 2021 · S/N 54944N973RLAeronautical Services Group Inc · Palmetto Bay, FLBuilt 2009 · S/N 53973N974HHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1999 · S/N 53329N975SCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 54940N977MSMaricopa County · Phoenix, AZBuilt 2014 · S/N 54519N982STTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 54939N985MCSt Tammany Parish Mosquito Abatement District · Slidell, LABuilt 2021 · S/N 54969N98DJAvex Xi LLC · Fort Lauderdale, FLS/N 56428N98EGHfs Heli V LLC · New York, NYBuilt 2018 · S/N 54813N98YJAir Methods LLC · Greenwood Village, COBuilt 2021 · S/N 54968N98ZA98za LLC · New York, NYBuilt 2015 · S/N 54635N991MHGeorgia Department Of Public Safety · Kennesaw, GABuilt 2013 · S/N 54408N997JSB29 Ups & Downs LLC · West Hartford, CTBuilt 2014 · S/N 54543N999GHGuardian Helicopters Inc · Fillmore, CABuilt 2008 · S/N 53868N99AMBell Textron Inc · Fort Worth, TXS/N 56494N99YJAir Methods LLC · Greenwood Village, COBuilt 2017 · S/N 54738
Back to AD 2001-01-52 R1