AD 2011-22-01

Registered aircraft · 1,167

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

N469RRLegacy Aviation Inc · Camden, DEBuilt 2004 · S/N 5055N46GXTexas Instruments Inc · Mc Kinney, TXBuilt 2011 · S/N 9469N470BBReina Capital LLC · Miami, FLBuilt 2004 · S/N 9150N472USU S Department Of Homeland Security · Arlington, VABuilt 2016 · S/N 6198N473ECBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5473N473USU S Department Of Homeland Security · Arlington, VABuilt 2016 · S/N 6242N474DMillard S Drexler Inc · Teterboro, NJBuilt 2005 · S/N 5083N474MJAir 47 LLC · Addison, TXBuilt 1997 · S/N 524N474TCJep Holdings LLC · Oklahoma City, OKBuilt 2013 · S/N 9601N475HAHawaiian Airlines Inc · Seattle, WABuilt 2001 · S/N 55121N476HAHawaiian Airlines Inc · Seattle, WABuilt 2001 · S/N 55118N477HAHawaiian Airlines Inc · Seatac, WABuilt 2001 · S/N 55122N478HAHawaiian Airlines Inc · Seattle, WABuilt 2001 · S/N 55123N479HAHawaiian Airlines Inc · Seattle, WABuilt 2001 · S/N 55124N480HAHawaiian Airlines Inc · Seattle, WABuilt 2001 · S/N 55125N481GVRegistered aircraftBuilt 2001 · S/N 648N483HAHawaiian Airlines Inc · Seattle, WABuilt 2001 · S/N 55128N484HAHawaiian Airlines Inc · Seatac, WABuilt 2001 · S/N 55129N485HAHawaiian Airlines Inc · Seatac, WABuilt 2001 · S/N 55130N486HAHawaiian Airlines Inc · Seattle, WABuilt 2001 · S/N 55131N487HAHawaiian Airlines Inc · Seattle, WABuilt 2001 · S/N 55132N487JGArtemis Aviation LLC · Houston, TXBuilt 2012 · S/N 9487N487JLZephyr Leasing LLC · Dover, DEBuilt 2010 · S/N 5301N48WGAlliance Aviation Group LLC · Wilmington, DEBuilt 2004 · S/N 9148N490BACisco Aero - N9739 LLC · Cisco, TXBuilt 2015 · S/N 9739N491HAHawaiian Airlines Inc · Seatac, WABuilt 2003 · S/N 55175N492HAHawaiian Airlines Inc · Seatac, WABuilt 2004 · S/N 55181N493HAHawaiian Airlines Inc · Seatac, WABuilt 2005 · S/N 55184N495HAHawaiian Airlines Inc · Seatac, WABuilt 2004 · S/N 55185N497ECEdf LLC · New York, NYBuilt 2010 · S/N 9396N497SBAdlaur Aviation LLC · St Thomas, VIBuilt 2009 · S/N 5238N499WREagle One II LLC · King Of Prussia, PABuilt 2011 · S/N 9458N5000PGeo Leasing LLC · Boca Raton, FLBuilt 2014 · S/N 9655N5000XTeratorn LLC · Seattle, WABuilt 2000 · S/N 611N500EURegistered aircraftBuilt 2018 · S/N 9838N500GFIntellectual Air LLC · Atlanta, GABuilt 2008 · S/N 5191N500VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9552N501GMSc Transport LLC · Torrance, CABuilt 2017 · S/N 5561N501MGRegistered aircraftBuilt 2006 · S/N 9215N501QCQuikrete Aircraft Leasing LLC · Atlanta, GABuilt 2013 · S/N 5450N501VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9563N502VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 9608N503GSRegistered aircraftBuilt 2003 · S/N 5005N503GVEmmanuel Group · North Wilkesboro, NCBuilt 2015 · S/N 5503N503VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9565N504VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9566N505DSwift Connections LLC · Los Angeles, CABuilt 2011 · S/N 5323N505VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9571N506HGKimberly-Clark Integrated Services Corp · Dallas, TXBuilt 2012 · S/N 5400N506VJTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2006 · S/N 9214
Back to AD 2011-22-01