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.

N1612Gm Leasing Co LLC · Broussard, LABuilt 1996 · S/N 53044N163RLRotorcraft Leasing Company LLC · Broussard, LAS/N 53163N164RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1997 · S/N 53140N165SPSouthern Utah University · Cedar City, UTBuilt 2000 · S/N 53458N168TBSouthwest Aviation Enterprises · Haslet, TXBuilt 2000 · S/N 53434N16SPState Of New York · Albany, NYBuilt 2002 · S/N 53532N171WHWestwind Helicopters Inc · Santa Fe, TXBuilt 1997 · S/N 53149N173SFGm Leasing Company LLC · Broussard, LAS/N 53978N175PAMansfield Helifight · Milton, VTBuilt 1997 · S/N 53154N179SFN179sf LLC · Chandler, AZBuilt 1996 · S/N 53196N17DEBell Textron Inc · Fort Worth, TXBuilt 2006 · S/N 53700N17DFDf Aviation LLC · Somerset, KYS/N 54922N17SPNew York State Police · Albany, NYBuilt 2000 · S/N 53444N181MAMinuteman Aviation Inc · Missoula, MTBuilt 2007 · S/N 53789N184AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54044N184SFGm Leasing Co LLC · Broussard, LABuilt 1996 · S/N 53087N189AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54047N18BHAbc Helicopters Inc · Jefferson, WIBuilt 1997 · S/N 53217N18DBN87bb LLC · Monroe, NCS/N 53165N18SPState Of New York · Albany, NYBuilt 2002 · S/N 53533N1903ADale County Sheriffs Office · Ozark, ALBuilt 2001 · S/N 53475N190AETextron Financial Corp · Wichita, KSBuilt 2014 · S/N 54511N193AETextron Financial Corp · Wichita, KSBuilt 2019 · S/N 54847N193AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54004N195DJAvex Xi LLC · Fort Lauderdale, FLBuilt 2021 · S/N 54941N196AEAir Evac Ems Inc · O Fallon, MOBuilt 2019 · S/N 54858N196TAHelo N426ha LLC · Richmond, VABuilt 2009 · S/N 53925N1MHIsaiah 40v31 LLC · Orlando, FLBuilt 2013 · S/N 54398N1MJLittle Ranger LLC · Jackson, WYBuilt 2024 · S/N 56404N203HAHelo N203ha LLC · Richmond, VABuilt 1996 · S/N 53023N206TLTurbines Ltd · West Point, NES/N 53589N207SJSan Juan Aviation LLC · Wilmington, DES/N 53721N208AMAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 54460N20BHChemair Helicopters Inc · Jefferson, WIBuilt 1998 · S/N 53242N20WHGulf Helicopters LLC · Santa Fe, TXBuilt 1999 · S/N 53377N214AMAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 54485N218AMAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 54565N218BHOsceola County Sheriffs Office · Kissimmee, FLBuilt 2006 · S/N 53704N219BHOsceola County Sheriffs Office · Kissimmee, FLBuilt 2002 · S/N 53525N219HAUS Trinity Equipment LLC · Argyle, TXBuilt 2008 · S/N 53859N21BHChemair Helicopters Inc · Jefferson, WIBuilt 1998 · S/N 53262N21CLHelicopters Inc · Linden, NJBuilt 2002 · S/N 53536N2222LLott Jeff S · Post, TXBuilt 1998 · S/N 53306N222LNMetro Aviation Inc · Shreveport, LAS/N 54808N223AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 53954N223FMTexas Department Of Public Safety · Austin, TXBuilt 2026 · S/N 56477N224AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 54070N224EKFraned Corp · Wilmington, DES/N 53924N225FMCoastal Investments Inc · Wilmington, DEBuilt 2000 · S/N 53425N229AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 54071
Back to AD 2001-01-52 R1