OpenAirDocs.org
AD 2013-22-21

Registered aircraft · 2,381

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.

N39049Aspen Helicopters Inc · Oxnard, CABuilt 1980 · S/N 3101N3906CLindemann Robert A · Holliday, TXBuilt 1981 · S/N 3243N390LHDsl Aviation LLC · Perham, MNBuilt 1977 · S/N 2234N390SFN390sf LLC · Chandler, AZBuilt 2000 · S/N 53407N39101Scotts Helicopter Service Inc · Le Sueur, MNBuilt 1981 · S/N 3289N3914RRotorcraft Leasing Company LLC · Broussard, LABuilt 2009 · S/N 53914N3917GBank Of Utah Trustee · Salt Lake City, UTBuilt 1974 · S/N 1364N391RLMsix Helicopters LLC · Slaughter, LABuilt 1981 · S/N 3271N392MUsda Forest Service Fepp · Helena, MTBuilt 1969 · S/N 362N393SSouthwest Heliservices LLC · Mesa, AZBuilt 1980 · S/N 45494N395AEAir Evac Ems Inc · O Fallon, MOS/N 45551N396RLMorris Equipment LLC · Yuma, AZBuilt 1980 · S/N 45-396N397RLBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 45397N398AMAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 54492N398WCBucks Air Charters Inc · Wilmington, DEBuilt 1976 · S/N 1966N399AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 52490N399MHBlade Leasing LLC · Homer, AKBuilt 1993 · S/N 52016N399SPSamaritans Purse · Boone, NCBuilt 2023 · S/N 56373N39AEAir Evac Ems Inc · O Fallon, MOBuilt 1997 · S/N 53103N39CLHelicopters Inc · Wilmington, DEBuilt 2004 · S/N 53612N39KMFirst Flight Of Wyoming LLC · Billings, MTBuilt 2014 · S/N 54502N39LRHornet LLC · Picayune, MSBuilt 1981 · S/N 45654N39MKXtreme Aviation LLC · Falkville, ALBuilt 1980 · S/N 2984N3DW T Waggoner Estates · Vernon, TXBuilt 2007 · S/N 4620N3KYCommonwealth Of Kentucky · Frankfort, KYFirst renewal noticeS/N 51113N3QYHelicopters Inc · Wilmington, DEBuilt 1999 · S/N 52224N3TVMission Air Capital Services L L C · San Antonio, TXS/N 2678N3WVState Of West Virginia · Charleston, WVBuilt 2006 · S/N 53713N3YJHelicopters Inc · Linden, NJBuilt 1994 · S/N 4322N400EEGore Nitrogen Pumping Service LLC · Seiling, OKBuilt 2013 · S/N 54457N400PJHelibro LLC · Red Bluff, CABuilt 2006 · S/N 53705N400UCPacific Rotors Inc · Oceanside, CABuilt 1974 · S/N 1407N4010GScotts Helicopter Services Inc · Le Sueur, MNBuilt 1968 · S/N 183N4013GRegistered aircraftS/N 171N401FNNy On Air LLC · Kearny, NJBuilt 1994 · S/N 52081N401FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLFirst renewal noticeBuilt 2006 · S/N 52327N401HSt Johns County Sheriff Office · Saint Augustine, FLBuilt 2024 · S/N 56387N401LFLife Flight Network LLC · Aurora, ORBuilt 2019 · S/N 54865N401PHPhi Health LLC · Tempe, AZBuilt 2004 · S/N 53615N401TDLeading Edge Aviation Inc · Bend, ORBuilt 2012 · S/N 54335N402AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52393N402FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLFirst renewal noticeBuilt 2006 · S/N 52328N402KTHelicopter Marketing Associates LLC · Colleyville, TXS/N 54639N402LFLife Flight Network LLC · Aurora, ORBuilt 2019 · S/N 54867N402MAMinuteman Aviation Inc · Missoula, MTBuilt 2008 · S/N 53834N402PDCity Of Omaha · Omaha, NEBuilt 2012 · S/N 54322N402PHPhi Health LLC · Tempe, AZBuilt 1997 · S/N 53159N402PJHelibro LLC · Red Bluff, CABuilt 1997 · S/N 53195N402TDAir Metro Helicopters Inc · New City, NYBuilt 1990 · S/N 51383N403APA & P Helicopters Inc · Richvale, CABuilt 2000 · S/N 53424
Back to AD 2013-22-21