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.

N559MTMed-Trans Corp · Denton, TXS/N 54999N55APTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 54718N55FSTm Helicopter LLC · Oviedo, FLBuilt 2012 · S/N 54094N55RTRt Oliver Investments Inc · Oklahoma City, OKS/N 53940N55SLHelicopters Inc · Cahokia, ILBuilt 2007 · S/N 52347N55UPAlba Leasing Services LLC · Scottsdale, AZBuilt 1983 · S/N 3750N560PK&D Aviation LLC · Kingston, OKBuilt 1982 · S/N 51013N560WMN390sf LLC · Chandler, AZBuilt 2006 · S/N 53706N561BACsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 54951N561SFN390sf LLC · Chandler, AZBuilt 2000 · S/N 53456N563AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52475N565VALuig Perry J · Holliday, TXS/N 3107N566AFRickards Aviation Group LLC · Dagsboro, DEBuilt 1981 · S/N 45565N56757Jbi South Leasing LLC · Pembroke, NHBuilt 1994 · S/N 52072N567AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52477N567DCFalcon Aviation & Jet Sales LLC · Parrish, FLBuilt 2021 · S/N 54945N567RJR J Corman Aviation Services LLC · Nicholasville, KYBuilt 2000 · S/N 53432N569THelicopters Inc · Wilmington, DEBuilt 2004 · S/N 52290N56ALBoard Of County Commissioners · Bartow, FLBuilt 1974 · S/N 1402N56AZState Of Arizona Department Of Public Safety · Phoenix, AZBuilt 2004 · S/N 53616N56BHPinnacle Helicopters Inc · Victoria, MNBuilt 1973 · S/N 1018N56BLHelicopters Inc · Cahokia, ILBuilt 1982 · S/N 3502N570JHHarnden Aviation Group LLC · Harrisburg, PABuilt 1980 · S/N 45428N570KDK&D Aviation LLC · Kingston, OKBuilt 1994 · S/N 52079N570LEHhl LLC · Denver, COS/N 45570N570RLJasons Helicopter Services · New Prague, MNBuilt 1980 · S/N 45517N570WMN390sf LLC · Chandler, AZBuilt 2006 · S/N 53708N57165Brown Helicopter Inc · Pensacola, FLS/N 3816N571CJRotorpro LLC · Sevierville, TNBuilt 1983 · S/N 45781N571DABank Of Utah Trustee · Salt Lake City, UTS/N 54640N572DABank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 54650N5733KEcolift Corp · San Juan, PRS/N 2951N5739VHb7 LLC · Sheridan, WYBuilt 1980 · S/N 3025N573CAChem-Air LLC · Shreveport, LABuilt 1975 · S/N 1785N5743HAspen Ag Helicopters Inc · Oxnard, CABuilt 1980 · S/N 3042N5743WFly Hangar 13 LLC · Mico, TXBuilt 1980 · S/N 3050N5743ZTate James D · St Croix, VIS/N 3051N57441Jbi South Leasing LLC · Pembroke, NHBuilt 1980 · S/N 45438N5745YMonarch Enterprises Inc · Kirkland, WABuilt 1980 · S/N 45531N5747WFly Hangar 13 LLC · Mico, TXBuilt 1979 · S/N 2812N5747XBlair Air Service Inc · Lemoore, CABuilt 1980 · S/N 3046N57491Monarch Enterprises Inc · Kirkland, WABuilt 1980 · S/N 45505N574AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52476N5750TScotts Helicopter Service · Le Sueur, MNBuilt 1980 · S/N 3095N5751MTrinkle Aviation LLC · Kingburg, CABuilt 1980 · S/N 45522N575NENebraska State Patrol · Lincoln, NEBuilt 2005 · S/N 53670N576KANorthwest Helicopters I Inc · Olympia, WABuilt 1976 · S/N 1971N576MRegistered aircraftBuilt 2017 · S/N 54698N579LBCollier Mosquito Control District · Naples, FLBuilt 2021 · S/N 54982N579SD2010 Leasing Group LLC · Torrance, CABuilt 1980 · S/N 3193
Back to AD 2013-22-21