OpenAirDocs.org
AD 2013-22-21

Registered aircraft · 2,382

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:2013-22-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2013-22-21')
  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.

N428TGNorthward Bound LLC · Anchorage, AKBuilt 2008 · S/N 53884N429AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52428N429CEDelcamp Michael · Richmond, TXS/N 2806N429MTMed-Trans Corp · Denton, TXBuilt 2013 · S/N 54129N429PHPhi Health LLC · Tempe, AZBuilt 2007 · S/N 53772N429ZACoastal Air Service Inc · Panama City, FLBuilt 1980 · S/N 45375N42FOchoco Wood Products LLC · Prineville, ORBuilt 1994 · S/N 52100N42SLHelicopters Inc · Wilmington, DEBuilt 2008 · S/N 52377N430AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52430N430CCCharleston County Sheriffs Office · North Charleston, SCBuilt 2024 · S/N 56400N430PHPhi Aviation LLC · Lafayette, LABuilt 2008 · S/N 53870N43142Scotts Helicopter Services Inc · Le Sueur, MNBuilt 1977 · S/N 1577N431AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 52441N431CAChem-Air LLC · Shreveport, LABuilt 1978 · S/N 2517N431PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 53857N4328Air Gov II LLC · Rome, NYBuilt 1994 · S/N 4328N432JSScott J B · Boise, IDBuilt 2011 · S/N 54320N432PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 53681N432TVSky Choppers LLC · Seneca, KSBuilt 1981 · S/N 3286N4338DAce High Helos LLC · Louise, TXBuilt 1992 · S/N 51560N4338GSouthwest Aviation Enterprises · Haslet, TXBuilt 2023 · S/N 56358N433HAHelo N433ha LLC · Richmond, VABuilt 1981 · S/N 3431N433JSScott J B · Boise, IDBuilt 2015 · S/N 54613N433PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 53861N433PHPhi Aviation LLC · Lafayette, LABuilt 2000 · S/N 53421N434AEAir Evac Ems Inc · Lewisville, TXBuilt 2013 · S/N 52450N434AMAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 54407N434PHPhi Health LLC · Tempe, AZBuilt 2007 · S/N 53773N435AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52446N43681World Trade Enterprises LLC · Lucas, TXS/N 773N436AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52447N437AEAir Evac Ems Inc · Lewisville, TXBuilt 2013 · S/N 52449N437MYLt Aviation LLC · Lexington, KYBuilt 1996 · S/N 53020N438AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52445N438PHPhi Aviation LLC · Lafayette, LABuilt 2004 · S/N 53622N439PHPhi Aviation LLC · Lafayette, LABuilt 2010 · S/N 53999N43AEAir Evac Ems Inc · O Fallon, MOBuilt 1978 · S/N 45187N43BRHighland Paving Co LLC · Fayetteville, NCBuilt 2022 · S/N 56312N43EEHelicopters Inc · Wilmington, DEBuilt 1999 · S/N 52219N43HHJohnson Flying Service LLC · Exira, IABuilt 1975 · S/N 1585N440AEAir Evac Ems Inc · O Fallon, MOBuilt 2013 · S/N 52453N440PHPhi Aviation LLC · Lafayette, LABuilt 1998 · S/N 53327N441LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56344N441PHPhi Aviation LLC · Lafayette, LABuilt 2011 · S/N 54081N442PHPhi Aviation LLC · Lafayette, LABuilt 2011 · S/N 54089N443BHBell Textron Inc · Fort Worth, TXS/N 54515N443LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56354N443PHPhi Aviation LLC · Lafayette, LABuilt 2012 · S/N 54090N4445HBell Textron Inc · Fort Worth, TXBuilt 1998 · S/N 4493N444AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52465
Back to AD 2013-22-21