OpenAirDocs.org
AD 2022-22-05

Registered aircraft · 34

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

N108JKustatan Leasing LLC · Nikiski, AKBuilt 2003 · S/N 39N300NWBlue Skys LLC · Phoenix, AZBuilt 2006 · S/N 300N321TEBerg Orvie E Trustee · Rock Springs, WYBuilt 2001 · S/N 32N345FBumblebee Ventures LLC · Mercer Island, WAS/N 304N34GRSeton Bruce B Jr · Port Townsend, WABuilt 2005 · S/N 55N35010Milazzo Air LLC · North Adams, MABuilt 2012 · S/N 310N350EXAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2010 · S/N 303N407CLValiair Ltd Co Trustee · Casper, WYBuilt 2007 · S/N 4000N423TSandpoint Aviation LLC · Sandpoint, IDBuilt 2003 · S/N 43N444JERanchlands LLC · Hyattville, WYBuilt 2006 · S/N 58N454LWAero 182 LLC · Moline, ILBuilt 2013 · S/N 313N500FAKingfisher Air Inc · Kodiak, AKS/N 40N602BCN602bc LLC · Wasilla, AKBuilt 2007 · S/N 105N629LMackay Restaurant Management Group Inc · Seattle, WABuilt 2003 · S/N 45N669BCPhantom Holdings LLC · Lexington, NEBuilt 2007 · S/N 103N705BHKingfisher Air Inc · Kodiak, AKBuilt 2004 · S/N 56N706MU S Dept Of The Interior · Boise, IDBuilt 2005 · S/N 52N709MUS Department Of The Interior · Boise, IDBuilt 2006 · S/N 100N7135DOba Leasing LLC · Mobile, ALBuilt 2011 · S/N 305N716MUS Department Of The Interior · Boise, IDBuilt 2007 · S/N 104N71KBSparless Air LLC · Wilmington, DEBuilt 2004 · S/N 47N748SECsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 306N749SECsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 308N751SECsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 312N753U S Department Of The Interior · Boise, IDBuilt 2003 · S/N 44N755EPCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 314N756EPCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 315N757EPCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 316N771ECCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 311N777ZBKingfisher Air Inc · Kodiak, AKBuilt 2000 · S/N 30N794U S Department Of The Interior · Boise, IDBuilt 2004 · S/N 51N796US Department Of The Interior · Boise, IDBuilt 2004 · S/N 50N818ESKingfisher Air Inc · Kodiak, AKBuilt 2004 · S/N 48N883MXBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 307
Back to AD 2022-22-05