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.

N531AGTwo Tails LLC · Las Vegas, NVBuilt 2002 · S/N 4564N531PAGm Leasing Company LLC · Broussard, LABuilt 2008 · S/N 53876N533RAEnglish Air Service LLC · Georgetown, TXBuilt 1970 · S/N 533N533TTWestern Farming LLC · Missoula, MTBuilt 1974 · S/N 1517N536PDWestchester County Department Of Public Safety · Hawthorne, NYBuilt 2024 · S/N 56390N536PWAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2015 · S/N 54577N53702Helicopter Applicators Inc · Gettysburg, PABuilt 1983 · S/N 51249N5373UTimberland Helicopters Inc · Ashland, ORBuilt 1988 · S/N 4011N537TMbm Aviation Consultants Inc · Wilmington, DEBuilt 1980 · S/N 2993N538TDEl Destino LLC · Monticello, FLBuilt 1996 · S/N 52169N539AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52468N53AEAir Evac Ems Inc · O Fallon, MOS/N 45300N53AMBell Textron Inc · Fort Worth, TXS/N 56493N53DJKeybank Na · Superior, COBuilt 2022 · S/N 56327N53JWLegacy Endeavors LLC · Bigfork, MTBuilt 1970 · S/N 581N53MAAg Air Inc · Johnstown, COBuilt 1977 · S/N 2285N53QD H Helicopter Inc · Mascoutah, ILS/N 4035N53VACommonwealth Of Virginia · North Chesterfield, VABuilt 2025 · S/N 56432N541MTTextron Financial Corp · Wichita, KSBuilt 2019 · S/N 54876N542MTLendingclub Bank Na · Boston, MABuilt 2020 · S/N 54887N543CCBighorn Flying Co LLC · Wood River, NEBuilt 1982 · S/N 3593N543MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 54909N543SAShier Aviation Corporation · San Diego, CAS/N 2674N544BTBell Textron Inc · Fort Worth, TXS/N 56524N545SAShier Aviation Corp · San Diego, CABuilt 1983 · S/N 51063N546MTAtlantic Union Bank · Alpharetta, GABuilt 2022 · S/N 54991N546SACertified Medical Enterprises LLC · Murrieta, CABuilt 1976 · S/N 1939N547AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52471N54AEAir Evac Ems Inc · O Fallon, MOBuilt 1978 · S/N 45157N54AZN179sf LLC · Chandler, AZBuilt 2004 · S/N 53588N54HKAir Methods LLC · Greenwood Village, COBuilt 2020 · S/N 54903N54NYWisk Aero LLC · Mountain View, CABuilt 1983 · S/N 45770N54SPIndiana State Police · Indianapolis, INS/N 51062N552AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52478N552CHOrange County Sheriff'S Office · Orlando, FLBuilt 2020 · S/N 54906N553AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52474N553EAEdgefield Aviation LLC · Sandy, ORBuilt 1966 · S/N 215N553HDHelicopters Inc · Wilmington, DEBuilt 1998 · S/N 53304N555ASAero Leasing Inc · Medford, ORBuilt 2004 · S/N 53591N555NBHelicopter Services Of Illinois LLC · Fisher, ILBuilt 1977 · S/N 2306N555PPEl Aero Services LLC · Elko, NVBuilt 1988 · S/N 4021N555SJApex59 LLC · Saint Paul, MNBuilt 1968 · S/N 308N555THRegistered aircraftBuilt 1973 · S/N 1173N555ZAN555za LLC · Clifton, NJBuilt 2006 · S/N 53703N556GRRegistered aircraftN-number assigned (import), not yet registeredS/N 56566N556NBBell Textron Inc · Fort Worth, TXS/N 54609N557FWSilver Creek Aviation Services · Fort Worth, TXBuilt 2012 · S/N 54373N557MTTextron Financial Corp · Wichita, KSBuilt 2024 · S/N 56409N558AEAir Evac Ems Inc · O Fallon, MOBuilt 2015 · S/N 52470N559AEAir Evac Ems Inc · O'Fallon, MOBuilt 2015 · S/N 52472
Back to AD 2013-22-21