OpenAirDocs.org
AD 2000-22-13

Registered aircraft · 30

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:2000-22-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:2000-22-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.

N12SPNew York State Police · Albany, NYBuilt 2000 · S/N 49069N16KKS & S Aviation Services Inc · Pacoima, CAS/N 49100N20SPNew York State Police · Albany, NYBuilt 2000 · S/N 49070N255MKPremier Aircraft Services LLC · Bakersfield, CABuilt 1996 · S/N 49007N34SFlying Tigers LLC · Jefferson City, MOBuilt 2002 · S/N 49092N40DPLondonaire LLC · Wichita Falls, TXBuilt 1997 · S/N 49035N427SPState Of New York · Albany, NYBuilt 2001 · S/N 49083N430AGMcmahon Helicopter Services Inc · Canton, MIBuilt 1998 · S/N 49045N430CFSan Juan Aviation LLC · Wilmington, DEBuilt 2006 · S/N 49118N430CGSan Juan Aviation LLC · Wilmington, DES/N 49062N430CMSan Juan Aviation LLC · Wilmington, DES/N 49090N430DWGear Aviation LLC · Missoula, MTBuilt 2001 · S/N 49079N430NYMcmahon Helicopter Services Inc · Canton, MIBuilt 2000 · S/N 49068N430STHigh Performance Helicopters Corp · Crestline, CABuilt 2000 · S/N 49071N430VPAerotrust Services Corp Trustee · Wilmington, DES/N 49005N430VRAerotrust Services Corp · Wilmington, DES/N 49002N430W430w LLC · Crestline, CABuilt 2001 · S/N 49086N430WHAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2006 · S/N 49114N431HFHeliflite Shares LLC · Newark, NJBuilt 1999 · S/N 49051N431LLHm Aviation Holdings LLC · Fort Pierce, FLS/N 49128N431SLMcmahon Helicopter Services Inc · Canton, MIBuilt 1997 · S/N 49023N432HFHeliflite Shares LLC · Kearny, NJBuilt 2000 · S/N 49064N432NYState Of New York · Albany, NYBuilt 2001 · S/N 49087N556UHMcmahon Helicopter Services Inc · Canton, MIBuilt 2006 · S/N 49117N557STShelby Patrick B Trustee · Dallas, TXBuilt 2002 · S/N 49091N5RHHms Holdings LLC · Charlotte, NCBuilt 2002 · S/N 49093N72073Arrow Aviation Co LLC · Broussard, LAS/N 49030N810SPSale Reported · Bakersfield, CASale reportedBuilt 2004 · S/N 49099N918SPAlbatross Air Inc · Beaver, WVBuilt 2004 · S/N 49101N991WTailwinds LLC · Houston, TXBuilt 2007 · S/N 49122
Back to AD 2000-22-13