OpenAirDocs.org
AD 97-24-02 R1

Registered aircraft · 597

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:97-24-02-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:97-24-02-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.

N605CSMfjc LLC · Boca Raton, FLBuilt 2009 · S/N 5801N605DATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5930N605DDDale P Holt Holdings LLC · Salt Lake City, UTBuilt 2011 · S/N 5871N605DSClearbrook Investments LLC · Boston, MABuilt 2008 · S/N 5760N605GSGreystone Aircraft Holdings LLC · New York, NYBuilt 2011 · S/N 5865N605JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 5427N605JMMillrock Aviation Financial LLC · Danbury, CTBuilt 2013 · S/N 5935N605JPJmp 605 LLC · Miami, FLBuilt 2012 · S/N 5919N605LCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 5740N605LFLevel Flight LLC · Jefferson City, MOBuilt 2009 · S/N 5794N605LTWeyerhaeuser Nr Co · Seattle, WABuilt 2012 · S/N 5923N605MMAa Not E LLC · New York, NYBuilt 2008 · S/N 5769N605NSFalcon Aviation & Jet Sales LLC · Parrish, FLBuilt 2009 · S/N 5806N605PATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5753N605RBAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2009 · S/N 5791N605RTMountaingate LLC · Jackson, WYBuilt 2012 · S/N 5917N605TKRoberts Asset Management Corp · Boston, MABuilt 2010 · S/N 5854N605TRTarco Aircraft Funding LLC · Fort Lauderdale, FLBuilt 2007 · S/N 5715N605VVSw Automotive Management Holdings LLC · Highlands Ranch, COBuilt 2008 · S/N 5773N606JLRegistered aircraftBuilt 1997 · S/N 5332N60BSBravo-Fox LLC · Atlanta, GABuilt 2010 · S/N 5834N610LValiair Lc Trustee · Casper, WYBuilt 2005 · S/N 5607N611ABPollard Spares LLC · Roanoke, TXBuilt 1997 · S/N 5324N611AZPaloma & Joan LLC · Dover, DEBuilt 2005 · S/N 5637N613JRGlobal Aviation Network LLC · Allentown, PABuilt 2016 · S/N 6070N614PJJem Leasing LLC · Etna, OHBuilt 2008 · S/N 5776N614SGTsg Holdings Company Ga LLC · Atlanta, GABuilt 1997 · S/N 5343N615BNOnward And Upward Aviation LLC · New York, NYBuilt 2008 · S/N 5762N617BWWhite Aviation Holdings LLC · Boston, MABuilt 2003 · S/N 5572N618CRLeidos Inc · Reston, VABuilt 2001 · S/N 5520N618JJJj Challenger 620tm LLC · Wilmington, DEBuilt 1999 · S/N 5440N618RRFat Boy Leasing LLC · Wilmington, DEBuilt 1988 · S/N 5022N619TSMavana Heli Support USA Inc · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1981 · S/N 1019N61FFPayne Aviation Weslaco LLC · Weslaco, TXBuilt 1994 · S/N 5166N620PJFth Acquisition Corp Vii · Richardson, TXNon-citizen corporation, flight hours not reportedBuilt 1994 · S/N 5169N621DJNorth Point Aviation LLC · San Francisco, CABuilt 1994 · S/N 5144N622DDanforth LLC · Columbus, OHBuilt 2020 · S/N 6161N622HAHamilton Aviation Inc · Portland, ORBuilt 2025 · S/N 6224N622JDMusashi Jets LLC · Del Valle, TXBuilt 1998 · S/N 5356N624EMGlobal Aircraft Trust Inc Trustee · Cheyenne, WYS/N 3039N624MYWhitehawk Holdings LLC · Tulsa, OKBuilt 2013 · S/N 5958N626KSHoltec Logistics LLC · Camden, NJBuilt 2013 · S/N 5952N627AFAmerican Fidelity Corp · Oklahoma City, OKBuilt 2002 · S/N 5548N628EFSn 5024 Corp · Fort Lauderdale, FLBuilt 1988 · S/N 5024N628GLXxx Ventures LLC · Austin, TXBuilt 2017 · S/N 6108N629HGHantz Air LLC · Southfield, MIBuilt 2011 · S/N 5880N62HAJn Equipment Leasing LLC · Seymour, CTBuilt 2012 · S/N 5925N630ARAar International Financial Services LLC · Wood Dale, ILBuilt 2009 · S/N 5797N633WMCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5951N640GRDodson International Parts Inc · Rantoul, KSS/N 5093
Back to AD 97-24-02 R1