OpenAirDocs.org
AD 2007-07-07 R1

Registered aircraft · 1,156

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:2007-07-07-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:2007-07-07-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.

N604RMFireproof Aviation LLC · Southfield, MIBuilt 2000 · S/N 5441N604SASe Aircraft Leasing LLC · Wilmington, DEBuilt 1999 · S/N 5408N604SBKhosla Ventures LLC · Menlo Park, CABuilt 2004 · S/N 5569N604SGGaf Holdings Inc · Visalia, CABuilt 1997 · S/N 5336N604TBBoeing Company · Berkeley, MOBuilt 2005 · S/N 5614N604VGNational Products Inc · Seattle, WABuilt 2003 · S/N 5562N604WARegistered aircraftBuilt 2004 · S/N 5594N604WBChoice Administrators Insurance Services Inc · Orange, CABuilt 1996 · S/N 5306N604XTJ Turbines Inc · Wilmington, DEBuilt 1996 · S/N 5307N604ZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 5496N605BCHeights Aviation LLC · Tucson, AZBuilt 2006 · S/N 5705N605BSStream Enterprises LLC · Marlborough, MABuilt 2013 · S/N 5950N605CEExpedient Voyages LLC · Westport, CTBuilt 2010 · S/N 5851N605CLTcp Aviation I LLC · Sacramento, CABuilt 2012 · S/N 5909N605CSMfjc 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 5332N609SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10020N60BSBravo-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 5637N611SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10035N612QXSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10042N613JRGlobal Aviation Network LLC · Allentown, PABuilt 2016 · S/N 6070N613SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10038N614PJJem Leasing LLC · Etna, OHBuilt 2008 · S/N 5776N614QXSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10049N614SGTsg Holdings Company Ga LLC · Atlanta, GABuilt 1997 · S/N 5343N614SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10051N615BNOnward 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 5520
Back to AD 2007-07-07 R1