Skip to content

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N810MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 17000026 N811FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 1994 · S/N 7029 N813AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8013 N813JATrademark Aviation LLC · Camden, DEBuilt 1996 · S/N 5308 N813LSLove Airlines LLC · Dallas, TXBuilt 1995 · S/N 5159 N813MSCypress Cove Air LLC · Phoenix, AZBuilt 1994 · S/N 5171 N813TAAjenat Holdings LLC · Washington, DCBuilt 2011 · S/N 5869 N814PSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 5544 N815MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 17000034 N818ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 5799 N818AFCorbin Aviation LLC · Durant, OKBuilt 1998 · S/N 5395 N818MDUmb Bank Na Trustee · Salt Lake City, UTS/N 17000039 N819AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8019 N820ASBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 7188 N820AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8020 N821AYLogos Aviation Inc · Fort Lauderdale, FLBuilt 2005 · S/N 8021 N821FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 2005 · S/N 8058 N823AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8023 N823KDEast Shore Aviation LLC · Fort Lauderdale, FLBuilt 2004 · S/N 5584 N823MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 17000044 N824AYBeautech Power Systems LLC · Dallas, TXBuilt 2005 · S/N 8024 N824DHPollard Spares LLC · Roanoke, TXBuilt 1985 · S/N 3047 N824MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 17000045 N825AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8025 N825SGPlane Fetch Charter LLC · Anaheim, CABuilt 1994 · S/N 5146 N826AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8026 N827AYLogos Aviation Inc · Fort Lauderdale, FLBuilt 2005 · S/N 8027 N828TKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5897 N828WGWg Aero LLC · Anchorage, AKBuilt 1991 · S/N 5080 N829AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8029 N82RLWkair 3 LLC · Boerne, TXBuilt 2001 · S/N 5485 N830AYGold Coast Aviation · Fort Lauderdale, FLBuilt 2005 · S/N 8030 N830CHWwbv Aviation LLC · Beachwood, OHBuilt 2013 · S/N 5954 N831AYBeautech Power Systems LLC · Dallas, TXBuilt 2005 · S/N 8031 N831FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 2006 · S/N 8061 N831PBRaynemen LLC · Pebble Beach, CABuilt 2012 · S/N 5895 N832AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 8032 N832SCNwt Aircraft Co · Lexington, KYBuilt 2023 · S/N 6189 N834AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 8034 N835AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8035 N836AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 8036 N836CMBel Aviation LLC · Nokomis, FLBuilt 1990 · S/N 5079 N8390ADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7390 N83UFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 5083 N8409NDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7409 N840AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8040 N8416BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7416 N841FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 2006 · S/N 8064 N841NPeninsula Air Logistics LLC · Palo Alto, CABuilt 2016 · S/N 6086 N841SDBluemont Leaf LLC · Houston, TXBuilt 2006 · S/N 5646

Back to AD 2007-07-07 R1