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.

N494PJHelibro LLC · Red Bluff, CABuilt 2006 · S/N 53694N495AEAir Evac Ems Inc · O Fallon, MOBuilt 1999 · S/N 53363N495PHPhi Aviation LLC · Lafayette, LABuilt 1999 · S/N 53397N495PJTwin Equipment LLC · Red Bluff, CABuilt 2009 · S/N 53949N496AEAir Evac Ems Inc · O Fallon, MOBuilt 1999 · S/N 53328N496PHPhi Aviation LLC · Lafayette, LABuilt 1999 · S/N 53398N496PJHelibro LLC · Red Bluff, CABuilt 2009 · S/N 53934N497AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 54687N497PPhi Health LLC · Tempe, AZBuilt 1998 · S/N 53277N498PPhi Health LLC · Tempe, AZBuilt 1998 · S/N 53283N499AEAir Evac Ems Inc · O Fallon, MOBuilt 1999 · S/N 53367N49BLSea Jay LLC · Raleigh, NCBuilt 2006 · S/N 53702N49TFBct Aviation LLC · Saint Martinville, LABuilt 1999 · S/N 53399N4HZHerzog Contracting Corp · Saint Joseph, MOBuilt 2007 · S/N 53779N500SCSouth Carolina Law Enforcement Division · Columbia, SCBuilt 2009 · S/N 53947N501MTTextron Financial Corp · Wichita, KSBuilt 2021 · S/N 54965N504BPBell Textron Inc · Fort Worth, TXBuilt 2004 · S/N 53609N505LELifeflight Eagle · Kansas City, MOBuilt 2001 · S/N 53470N505MTMed-Trans Corp · Denton, TXBuilt 1998 · S/N 53307N506MCManatee County Sherriffs Office · Bradenton, FLS/N 54722N506MTMed Trans Corp · Denton, TXBuilt 2001 · S/N 53511N507EZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 56413N507GAFlagstaff Medical Center Inc · Flagstaff, AZBuilt 2013 · S/N 54466N507SPState Of Indiana · Indianapolis, INS/N 54701N508MTMed-Trans Corp · Denton, TXBuilt 1998 · S/N 53326N508SPLouisiana State Police · Baton Rouge, LABuilt 2016 · S/N 54666N509AAGm Leasing Company LLC · Broussard, LABuilt 2006 · S/N 53716N509MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 54099N50GVHelicopters Inc · Wilmington, DEBuilt 2019 · S/N 54864N50QHelicopters Inc · Linden, NJBuilt 2003 · S/N 53565N511MTMed-Trans Corp · Denton, TXBuilt 2003 · S/N 53563N511PDCity Of Detroit · Detroit, MIBuilt 1998 · S/N 53292N512TPCity Of Tampa · Tampa, FLBuilt 2002 · S/N 53546N512VBCae III Ltd · Wilmington, DEBuilt 2014 · S/N 54156N513ESBell Textron Inc · Fort Worth, TXS/N 56513N513MTMed-Trans Corp · Denton, TXBuilt 2018 · S/N 54741N515MTMed-Trans Corp · Denton, TXBuilt 2004 · S/N 53604N516MTMed-Trans Corp · Denton, TXBuilt 2007 · S/N 53762N518DSVolusia Sheriffs Office · Deland, FLBuilt 2023 · S/N 56353N518MTMed Trans Corp · Denton, TXBuilt 2009 · S/N 53915N519MTMed-Trans Corp · Denton, TXBuilt 2009 · S/N 53956N519RSLindsey Aviation Services · Haslet, TXBuilt 2019 · S/N 54843N519SFN179sf LLC · Chandler, AZS/N 53007N51DJAvex Xi LLC · Fort Lauderdale, FLS/N 56516N5200752007 LLC · Boston, MABuilt 2023 · S/N 56334N520MTMed-Trans Corp · Denton, TXBuilt 2007 · S/N 53805N521MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 54750N521RCMed-Trans Corp · Denton, TXBuilt 2014 · S/N 54496N522MTMed-Trans Corporation · Denton, TXBuilt 1998 · S/N 53272N522RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1997 · S/N 53231
Back to AD 2001-01-52 R1