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.

N67882Mf Helicopters LLC · Troy, WIBuilt 1995 · S/N 5222N67907Churchill Scott · Jordan, MNBuilt 1995 · S/N 5223N67908Usda Aphis Ws · Cedar City, UTBuilt 1995 · S/N 5224N67915Stovall Eric M · Marathon, TXBuilt 1995 · S/N 5225N67919Ko Hee · Norwood, NJBuilt 1995 · S/N 5226N67937Churchill Scott · Jordan, MNBuilt 1995 · S/N 5227N67939City Of Jackson Tennessee · Jackson, TNBuilt 1995 · S/N 5228N67950United States Army · Redstone Arsenal, ALBuilt 1995 · S/N 5229N67952City Of Jackson Tennessee · Jackson, TNBuilt 1995 · S/N 5230N67960Dakota Air Parts International Inc · Fargo, NDBuilt 1995 · S/N 5232N67961Brown Helicopter Inc · Pensacola, FLBuilt 1995 · S/N 5233N67968United States Army · Redstone Arsenal, ALBuilt 1995 · S/N 5235N67978Mf Helicopters LLC · East Troy, WIBuilt 1995 · S/N 5237N679AGUsda Aphis Wildlife Services · Cedar City, UTBuilt 1994 · S/N 5188N67AJVictor Bravo LLC · Breaux Bridge, LAS/N 56318N67CLHelicopters Inc · Linden, NJBuilt 2000 · S/N 4530N67FABas Part Sales LLC · Greeley, COBuilt 1994 · S/N 5168N67JJTre Aviation Corp · Wilmington, DES/N 4062N67SJSan Juan Aviation LLC · Wilmington, DES/N 51098N681FGM&D Investment Holdings LLC · Red Bluff, CABuilt 2007 · S/N 53753N682BHBa Group LLC · Glastonbury, CTBuilt 2009 · S/N 4682N684AEAir Evac Ems Inc · O Fallon, MOBuilt 2016 · S/N 52484N684HWilson White Aircraft Industries LLC · Lewiston, IDBuilt 1996 · S/N 53065N686AMAir Methods LLC · Greenwood Village, COBuilt 1997 · S/N 53160N686RHCrosswind Leasing LLC · Prescott, AZBuilt 2006 · S/N 53714N687AMAir Methods LLC · Greenwood Village, COBuilt 2001 · S/N 53497N68AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45647N68GGJa Aviation Services LLC · Kalispell, MTBuilt 1975 · S/N 1792N68PHMercury Aviation Inc · Flowood, MSBuilt 1988 · S/N 3988N693AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54625N694AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54013N694PAGm Leasing Company LLC · Broussard, LABuilt 2001 · S/N 53482N695MCTom Cline Helicopter LLC · Lake Ozark, MOBuilt 1968 · S/N 300N696AMAir Methods LLC · Greenwood Village, COS/N 53564N696STState Of Michigan · Lansing, MIBuilt 2011 · S/N 54068N697AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54628N69875Gateway Youth Aeronautical Foundation · Maryland Heights, MOBuilt 2001 · S/N 5282N6989XArrow Aviation Company LLC · Broussard, LAS/N 53113N69FHelicopters Inc · Cahokia, ILBuilt 1996 · S/N 53025N69SGHarvey Gulf International Marine LLC · New Orleans, LABuilt 2008 · S/N 53827N6BUAgricultural Air Services LLC · Jupiter, FLBuilt 1988 · S/N 4034N6HEHelicopter Express LLC · Atlanta, GAS/N 53235N6NJNew Jersey State Police · West Trenton, NJBuilt 1995 · S/N 52107N6QDSierra Golf Rotorcraft LLC · Wilmington, DEBuilt 1992 · S/N 4247N6QPHelicopters Inc · Cahokia, ILS/N 52191N6TYMooney Seven Inc · San Antonio, TXBuilt 1992 · S/N 52007N6ULHelicopters Inc · Wilmington, DEBuilt 1993 · S/N 52015N6WVState Of West Virgina Dept Of Avn · Charleston, WVS/N 3138N6YJHelicopters Inc · Linden, NJBuilt 1996 · S/N 53066N7007RDiaz Mark · Madera, CABuilt 2019 · S/N 54839
Back to AD 2013-22-21