AD 2001-20-03

Registered aircraft · 224

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-20-03')
    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-20-03')
  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.

N238SRApple Realty Group Inc · Richmond, VABuilt 2015 · S/N 52469N23HXWillow Shade II Ltd · Englewood, COBuilt 2007 · S/N 52349N24191Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 52235N27MHelicopters Inc · Wilmington, DEBuilt 1993 · S/N 52045N295SJPremier Rotors LLC · Saint Martinville, LABuilt 1994 · S/N 52059N29WWPremier Rotors LLC · Saint Martinville, LABuilt 1995 · S/N 52157N2WEWe Explore LLC · Redlands, CABuilt 1993 · S/N 52027N301JASale Reported · Oklahoma City, OKSale reportedBuilt 2006 · S/N 52341N305MHMaritime Helicopters Inc · Homer, AKBuilt 2004 · S/N 52292N311MHMaritime Helicopters Inc · Homer, AKBuilt 1996 · S/N 52055N314AEAir Evac Ems Inc · O Fallon, MOBuilt 1999 · S/N 52222N314MHBlade Leasing LLC · Homer, AKBuilt 1995 · S/N 52119N316MHMaritime Helicopters Inc · Homer, AKBuilt 2006 · S/N 52323N317Magic Carpet Aviation LLC · San Antonio, TXBuilt 1993 · S/N 52014N318RLOcean Air Helicopters Inc · Port Orford, ORBuilt 2005 · S/N 52318N319AEAir Evac Ems Inc · O Fallon, MOS/N 52040N325AEAir Evac Ems Inc · O Fallon, MOBuilt 1993 · S/N 52009N336AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52436N338AEGm Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52087N346BFState Of Washington · Olympia, WAFirst renewal noticeBuilt 2007 · S/N 52346N34RMCrm Holdings LLC · Missoula, MTBuilt 2006 · S/N 52333N352TCHillsborough County Board Of County Commissioners · Tampa, FLS/N 52390N355AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52425N357SPLouisiana Department Of Public Safety · Baton Rouge, LABuilt 1996 · S/N 52161N35NRCentral States Helicopters Inc · Wood River, NEBuilt 1995 · S/N 52137N361DT925dt LLC · Picayune, MSBuilt 1994 · S/N 52080N378JCLongranger IV LLC · Missoula, MTBuilt 2013 · S/N 52448N385RLSan Juan Aviation LLC · Wilmington, DEBuilt 2008 · S/N 52385N386VCCounty Of Volusia · Deland, FLBuilt 1996 · S/N 52179N38BZHelicopters Inc · Wilmington, DEBuilt 1995 · S/N 52128N399AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 52490N399MHBlade Leasing LLC · Homer, AKBuilt 1993 · S/N 52016N3QYHelicopters Inc · Wilmington, DEBuilt 1999 · S/N 52224N401FNNy On Air LLC · Kearny, NJBuilt 1994 · S/N 52081N401FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLFirst renewal noticeBuilt 2006 · S/N 52327N402AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52393N402FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLFirst renewal noticeBuilt 2006 · S/N 52328N404AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52434N404MPIndustrial Helicopters LLC · Lafayette, LABuilt 1994 · S/N 52083N405LPGm Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52085N406KKKehler Kelly · Saint Xavier, MTBuilt 2004 · S/N 52283N406MPGm Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52086N407AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52409N408AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52408N409AEAir Evac Ems Inc · O Fallon, MOBuilt 2010 · S/N 52413N410AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52435N414AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52404N415AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52399N416AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52403N417AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52463
Back to AD 2001-20-03