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.

N57EFCk Helicopters LLC · Jasper, INBuilt 1971 · S/N 660N57KKPath Clear LLC · Wilmington, DES/N 4047N57LPPanther Helicopters Inc · Belle Chasse, LAS/N 52185N57ZT&T Transportation Inc · Lafayette, INBuilt 1980 · S/N 3016N58003San Juan Aviation LLC · Wilmington, DEBuilt 1983 · S/N 1020N58140San Juan Aviation LLC · Wilmington, DEBuilt 1973 · S/N 1108N581SCShelby County Sheriffs Office · Columbiana, ALBuilt 1995 · S/N 5201N582RAMarks Assets Group LLC · Lafayette, LABuilt 1979 · S/N 3582N583HBank Of Utah Trustee · Salt Lake City, UTS/N 54758N583MS & S 1165 Investments LLC · Austin, TXBuilt 1992 · S/N 51583N5843Gm Leasing Co LLC · Broussard, LABuilt 1991 · S/N 51467N58436Valiair Limited Co Trustee · Casper, WYBuilt 2013 · S/N 54394N586SCInterstate Helicopters Inc · Bethany, OKBuilt 1976 · S/N 2033N58765State Of Montana · Helena, MTBuilt 2001 · S/N 5276N588AEAir Evac Ems Inc · O Fallon, MOBuilt 2016 · S/N 52488N588MAMercury Aviation Inc · Flowood, MSS/N 51350N588TWWillfish LLC · Mentor, OHBuilt 2005 · S/N 4590N589AEAir Evac Ems Inc · O'Fallon, MOBuilt 2016 · S/N 52489N58AZState Of Arizona · Phoenix, AZBuilt 2006 · S/N 53736N58MIndustrial Power Services Corp · Ware, MABuilt 1974 · S/N 1310N591PAGm Leasing Co LLC · Broussard, LABuilt 2013 · S/N 54456N592PDWestchester County Dept Of Public Safety Trnspn · Hawthorne, NYBuilt 2011 · S/N 54073N59383N57aw LLC · Glendale, AZBuilt 1973 · S/N 1150N59427Ambrosini Helicopters Inc · Fresno, CAS/N 1132N59479Summit Helicopters Inc · Salem, VABuilt 1973 · S/N 1194N59495Knutson Flying Service Inc · Tioga, NDBuilt 1954 · S/N 1373N594RLGm Leasing LLC · Broussard, LABuilt 2004 · S/N 53594N59548Hendrickson Flying Service Inc · Rochelle, ILBuilt 1974 · S/N 1386N59553Sycan Corp · Paso Robles, CABuilt 1974 · S/N 1451N59564Sale Reported · Topeka, KSSale reportedBuilt 1974 · S/N 1389N59578Ag-Air Inc · Oakdale, CAS/N 1475N59579American Ag Aviation Inc · Five Points, CABuilt 1968 · S/N 1480N595AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45244N59600Henke Jeff A · Perry, OKS/N 1420N59604East End Helicopter LLC · Oak Ridge, NCBuilt 1974 · S/N 1490N59612Ranger Aviation Leasing LLC · Wilmington, DES/N 1500N59AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45291N59CHAir Center Helicopters Inc · Burleson, TXS/N 45284N59PRInternational Air Services Inc Trustee · Carson City, NVBuilt 2019 · S/N 54832N59WHGm Leasing Company LLC · Broussard, LABuilt 1998 · S/N 53261N5JUMoor Halley R Jr · Hankamer, TXBuilt 1981 · S/N 3427N5NUHawkeye Helicopter LLC · Lyndon, KSBuilt 1971 · S/N 722N5NYHelicopters Inc · Wilmington, DEBuilt 2001 · S/N 53474N5QPHelicopters Inc · Cahokia, ILBuilt 1981 · S/N 3457N5QVHelicopters Inc · Cahokia, ILS/N 3098N5QYHeliinc LLC · Linden, NJBuilt 2013 · S/N 52455N5TCCity Of Atlanta · Atlanta, GABuilt 1977 · S/N 2282N5TVHelicopters Inc · Linden, NJBuilt 1988 · S/N 4036N5WBHelicopter Solutions Mt Inc · Laurel, MTBuilt 1972 · S/N 855N5WVState Of West Virginia · Charleston, WVBuilt 2003 · S/N 52279
Back to AD 2013-22-21