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.

N618JJJj Challenger 620tm LLC · Wilmington, DEBuilt 1999 · S/N 5440N618RRFat Boy Leasing LLC · Wilmington, DEBuilt 1988 · S/N 5022N61FFPayne 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 5356N624MYWhitehawk Holdings LLC · Tulsa, OKBuilt 2013 · S/N 5958N625CASkywest Airlines Inc · St George, UTBuilt 2003 · S/N 10113N626KSHoltec 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 5880N629SYSkywest Airlines Inc · Saint George, UTBuilt 2024 · S/N 17000986N62HAJn 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 5951N638RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000053N639RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000057N640GRDodson International Parts Inc · Rantoul, KSS/N 5093N640RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000058N641CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10122N641RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000062N642RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000063N647RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000067N648CR7107 Associates LLC · Wilmington, DEBuilt 2005 · S/N 5633N648RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000068N648SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 5720N64JSCelebration Tv America Inc · Houston, TXBuilt 1992 · S/N 5119N64LELuxury Jet Acquisitions Inc · Newville, ALBuilt 1988 · S/N 5031N650ADAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2019 · S/N 6135N650BSBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 6078N650CFTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2019 · S/N 6136N650DWGbhp Associates LLC · Saratoga Springs, NYBuilt 2024 · S/N 6208N650ELBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 6138N650FBSierra Nevada Company LLC · Sparks, NVBuilt 2025 · S/N 6226N650GEFlying High Leasing LLC · Atlanta, GABuilt 2019 · S/N 6132N650GKGekabi Aviation LLC · The Woodlands, TXBuilt 2016 · S/N 6065N650GPOcean Acquisition 3 LLC · Denver, COBuilt 2018 · S/N 6124N650HJLambro Aircraft Management LLC · Hillsboro Beach, FLBuilt 2006 · S/N 5653N650HNTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 6160N650JRRegistered aircraftBuilt 2016 · S/N 6081N650LCAgco Corp · Duluth, GABuilt 2017 · S/N 6098N650RSSchumacher Oil LLC · Whitefish, MTS/N 7779N650SKPnc Bank Na · Boise, IDBuilt 2017 · S/N 6096N651AMAirmed International LLC · Birmingham, ALBuilt 2011 · S/N 5883N651JDA S K Equipment Leasing LLC · Cumming, GABuilt 2012 · S/N 5921N651LSWestwind Air Holdings Inc · Wilmington, DEBuilt 1999 · S/N 5413
Back to AD 2007-07-07 R1