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.

N509AAGm Leasing Company LLC · Broussard, LABuilt 2006 · S/N 53716N509MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 54099N50GVHelicopters Inc · Wilmington, DEBuilt 2019 · S/N 54864N50QHelicopters Inc · Linden, NJFirst renewal noticeBuilt 2003 · S/N 53565N50TVJet Ranger LLC · Cuyahoga Falls, OHBuilt 1994 · S/N 4320N511MTMed-Trans Corp · Denton, TXBuilt 2003 · S/N 53563N511PDCity Of Detroit · Detroit, MIBuilt 1998 · S/N 53292N512SCSan Juan Aviation LLC · Wilmington, DEBuilt 1987 · S/N 3967N512TPCity Of Tampa · Tampa, FLBuilt 2002 · S/N 53546N512VBCae III Ltd · Wilmington, DEBuilt 2014 · S/N 54156N513ESBell Textron Inc · Fort Worth, TXS/N 56513N513MTMed-Trans Corp · Denton, TXBuilt 2018 · S/N 54741N514RLSlikker Flying Service Inc · Buttonwillow, CABuilt 1991 · S/N 51514N515BGMonmouth County Shade Tree Commission · Freehold, NJBuilt 2002 · S/N 4560N515MTMed-Trans Corp · Denton, TXBuilt 2004 · S/N 53604N516LERotor Republic LLC · Orlando, FLBuilt 1978 · S/N 45162N516MTMed-Trans Corp · Denton, TXBuilt 2007 · S/N 53762N518DSVolusia Sheriffs Office · Deland, FLBuilt 2023 · S/N 56353N518MTMed Trans Corp · Denton, TXBuilt 2009 · S/N 53915N518ZRotormate LLC · Royse City, TXBuilt 1987 · S/N 3991N519MTMed-Trans Corp · Denton, TXBuilt 2009 · S/N 53956N519RSLindsey Aviation Services · Haslet, TXBuilt 2019 · S/N 54843N519SFN179sf LLC · Chandler, AZS/N 53007N51DJAvex Xi LLC · Fort Lauderdale, FLS/N 56516N5200752007 LLC · Boston, MABuilt 2023 · S/N 56334N520MDerstine Air Service LLC · Souderton, PABuilt 1978 · S/N 2454N520MTMed-Trans Corp · Denton, TXBuilt 2007 · S/N 53805N520RLPremier Rotors LLC · Saint Martinville, LABuilt 1993 · S/N 52052N521MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 54750N521RCMed-Trans Corp · Denton, TXBuilt 2014 · S/N 54496N522MAProvine Helicopter Service Inc · Greenwood, MSBuilt 1980 · S/N 2986N522MTMed-Trans Corporation · Denton, TXBuilt 1998 · S/N 53272N522RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1997 · S/N 53231N523PCSacramento Executive Helicopters Inc · Acampo, CABuilt 2008 · S/N 53875N523RLLarson Helicopters LLC · Perham, MNBuilt 2005 · S/N 52321N523TDTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 52388N524SPArkansas State Police · Little Rock, ARBuilt 2008 · S/N 53881N5259NBex Inc · Wilmington, DEBuilt 1997 · S/N 53192N526HAHelo N526ha LLC · Richmond, VABuilt 2000 · S/N 4541N527MTMed-Trans Corp · Denton, TXBuilt 2018 · S/N 54828N528AMAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 56459N528HPCollective Ag LLC · Osceola, NEBuilt 1971 · S/N 631N528MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 54829N52AEAir Evac Ems Inc · O Fallon, MOS/N 45758N52BHNipper Troy R · Texarkana, TXS/N 1652N52FAZma LLC · North Little Rock, ARBuilt 1981 · S/N 3424N52GHPleasant Gap Land Co Inc · State College, PABuilt 1989 · S/N 51276N52PLParatus Air DBA · Auburn, INS/N 45744N52ZSouthern Helicopter Service Inc · Millington, TNS/N 2251N530RRVertical Access Helicopters LLC · Clermont, FLS/N 1302
Back to AD 2013-22-21