OpenAirDocs.org
AD 98-24-03 R1

Registered aircraft · 838

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

N907PHShore Capital Aviation LLC · Chicago, ILBuilt 2006 · S/N 9210N907WSN907ws Aviation LLC · Honolulu, HIBuilt 2005 · S/N 9176N90FXCitation X Parts LLC · Liberty, NCBuilt 1999 · S/N 9017N90JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 552N9102Tvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 551N9103JSn 9103 LLC · Dover, DEBuilt 2002 · S/N 9103N910ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55086N912GGGf Management Company LLC · Durham, NCBuilt 2016 · S/N 6193N912MTUS Bank Na · Marshall, MNBuilt 2015 · S/N 9699N913SPLockton Enterprises Inc · Kansas City, MOBuilt 1997 · S/N 516N915ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55085N915BDDillards Inc · Little Rock, ARBuilt 2002 · S/N 690N915JGBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 9115N917RPadaca Global LLC · Hollywood, FLBuilt 1998 · S/N 9008N918TBScout Aviation IV LLC · New York, NYBuilt 2014 · S/N 9613N918WBChoice Administrators Insurance Services Inc · Orange, CABuilt 2005 · S/N 5072N919EMTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2011 · S/N 9451N919PETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6243N91LAAviation Leasing Co LLC · New York, NYBuilt 2003 · S/N 5027N920ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55083N921ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55082N922ATDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 55050N923ATDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 55051N924ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55080N925ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55079N925GTenax Aerospace LLC · Ridgeland, MSBuilt 2001 · S/N 9025N926ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55078N926PNSn 9003 LLC · Van Nuys, CABuilt 1997 · S/N 9003N928ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55076N928NJPeoples Choice Consulting LLC · Laguna Beach, CABuilt 2004 · S/N 5013N929ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55075N92FXFlexjet LLC · Cleveland, OHBuilt 2004 · S/N 9147N92LABaxter Investment Company LLC · Morristown, NJBuilt 2003 · S/N 5002N930ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55072N930ENE Management LLC · New York, NYBuilt 1999 · S/N 9040N930GLRegistered aircraftBuilt 2015 · S/N 6128N930LSSadie Aviation LLC · Houston, TXBuilt 1999 · S/N 580N932ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55073N933ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55071N933EYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 9731N933HHoneywell Aerospace US LLC · Phoenix, AZBuilt 2005 · S/N 5077N933MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 9504N934ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55070N934HEJemb Gv LLC · New York, NYBuilt 1999 · S/N 564N934JMMch Air LLC · New York, NYBuilt 2015 · S/N 9748N935ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55069N936ATDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 55058N937ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55091N939GSRegistered aircraftBuilt 2014 · S/N 9663N93MTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 6333
Back to AD 98-24-03 R1