AD 2021-23-13

Registered aircraft · 11,300

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:2021-23-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2021-23-13')
  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.

N102AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 54721N102AFMjm Enterprises LLC · Wilmington, DEBuilt 2007 · S/N 1779N102AJBird Dog Aircraft LLC · Billings, MTS/N 7868N102BBNester Randal K · Seguin, TXBuilt 1959 · S/N 1107N102BFBell Textron Inc · Fort Worth, TXBuilt 2013 · S/N 57185N102CGSale Reported · Surprise, AZSale reported, pending cancellationBuilt 1998 · S/N LNO85N102CQChatham County · Savannah, GABuilt 1999 · S/N 0901FFN102CVPilot In Command LLC · Parker, COBuilt 1999 · S/N 0570N102LUBlueskykai LLC · Wilmington, DEBuilt 1991 · S/N S1548N102NJUsda Forest Service Fepp · Trenton, NJBuilt 1975 · S/N 1671N102SHScotts Helicopter Services Inc · Le Sueur, MNBuilt 1971 · S/N 7762N102SUSignature Property Holdings LLC · Wilmington, DES/N 700736DN102SWGeorgia Helicopter Leasing Corp · Douglasville, GABuilt 2012 · S/N 0106N102UMTimberland Helicopters Inc · Ashland, ORBuilt 1981 · S/N 5075N102WPGarcia Randy S · Montebello, CABuilt 1991 · S/N S1572N10375Tactical Turtle LLC · Ortanna, PAS/N 67-18376N1038NSome Beech LLC · Bolivar, MOS/N 85-0360N103AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45597N103CGCity Of Burbank · Burbank, CABuilt 2006 · S/N LN102N103HXHelicopter Express LLC · Chamblee, GABuilt 2024 · S/N 39125N103JAJoann Air Inc · Mulberry, FLFirst renewal noticeS/N 782N103JPCity Of Jacksonville Sheriffs Office · Jacksonville, FLBuilt 2021 · S/N 54946N103MTMed Trans Corp · Denton, TXBuilt 2009 · S/N 9286N103NJUsda Forest Service Fepp · Trenton, NJBuilt 1969 · S/N 361N103VUAir Methods LLC · Greenwood Village, COS/N 9054N1042CRmi Air LLC · Ocilla, GAS/N 846N1043TCroman Corp · White City, ORBuilt 1961 · S/N 61083N1048PAviation Solution Experts LLC · St Marys, IAS/N 635N1048YCroman Corp · White City, ORBuilt 1961 · S/N 61161N104AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 54733N104AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2021 · S/N 21016N104APRock Creek Leasing LLC · Sapulpa, OKBuilt 1990 · S/N 4149N104EGSpitzer Helicopter LLC · Wilmington, DEBuilt 2013 · S/N 2266N104HHHaddock Flying Service Inc · Salters, SCBuilt 1960 · S/N 2062N104LNPathfinder Leasing LLC · Anchorage, AKBuilt 2006 · S/N 4094N104RLVertical Vegetation Management LLC · Darlington, INS/N 4315N104RTBack Nine Aerial LLC · New Berlin, WIBuilt 1990 · S/N 51364N104SUSignature Property Holdings LLC · Wilmington, DEBuilt 1977 · S/N 670151DN104TEN104te LLC · Tucumcari, NMBuilt 2011 · S/N 13093N104TVFdfah LLC · Chula Vista, CABuilt 1978 · S/N 2379N105ACAgricultural Air Services LLC · Jupiter, FLBuilt 1978 · S/N 580316DN105AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54024N105APBearing Tree Land Surveying LLC · Oklahoma City, OKBuilt 1995 · S/N 4381N105ATQualitair LLC · MichelstadtBuilt 2006 · S/N 4601N105CMLewis Donn C · Millington, MIBuilt 1966 · S/N 66-0587N105GKBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N S-458N105JDHavens Aviation LLC · Blacklick, OHBuilt 1973 · S/N 1105N105KYRobinson Helicopter Co · Torrance, CAS/N 1557N105LHHelilease LLC · Lewes, DEBuilt 1979 · S/N 2185N105LPEnright Arne P Trustee · Ward Cove, AKBuilt 1980 · S/N 3068
Back to AD 2021-23-13