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.

N8886AGold Coast Aviation · Fort Lauderdale, FLBuilt 2003 · S/N 7886 N888DHCanadair 5305 LLC · Dover, DEBuilt 1996 · S/N 5305 N888GBRegistered aircraftBuilt 2008 · S/N 5771 N888QLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 5566 N888YCJamm Leasing II LLC · Park City, UTBuilt 1999 · S/N 5402 N8891AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7891 N8896AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7896 N889ASFrontera Flight Holdings Inc · Dover, DEBuilt 2001 · S/N 7538 N889MCPnc Bank Na · Boise, IDBuilt 2025 · S/N 6217 N89Federal Aviation Administration · Oklahoma City, OKBuilt 2009 · S/N 5815 N8908DSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7908 N890SARi Millennium I LLC · Beverly, MABuilt 2001 · S/N 7548 N8921BAm Pm Services LLC · Northbrook, ILBuilt 2004 · S/N 7921 N8930EBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 7930 N8933BGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7933 N8936AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7936 N893TASta Aviation Management · New York City, NYBuilt 1983 · S/N 3016 N8940EAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7940 N8942AViajet LLC · Johnstown, PABuilt 2004 · S/N 7942 N8943AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7943 N8944BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 7944 N8946ABank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 7946 N8948BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 7948 N895CCK & S Aircraft LLC · Scottsdale, AZBuilt 2007 · S/N 5727 N8960AAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7960 N8964EAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7964 N8969AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7969 N8970DGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7970 N8971AAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7971 N8974CSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7974 N8976ESlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7976 N8980AViajet LLC · Johnstown, PABuilt 2004 · S/N 7980 N8982AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7982 N8986BSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7986 N898AKPoppa Air II LLC · Wellesley, MABuilt 2001 · S/N 5490 N90Federal Aviation Administration · Oklahoma City, OKBuilt 2009 · S/N 5817 N900BHAis Aviation LLC · Newark, DEBuilt 2004 · S/N 5601 N900EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7608 N900UCBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 5519 N901EVSkywest Airlines Inc · Saint George, UTBuilt 2002 · S/N 7616 N902AGT C Management Of Florida Inc · Naples, FLBuilt 2001 · S/N 5512 N902BResurrection House For All Nations Inc · Union City, GABuilt 1987 · S/N 5005 N902BWGoodfriend Aviation LLC · Knoxville, TNBuilt 2011 · S/N 5862 N902EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7620 N902FJSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 15002 N903AGPnc Bank Na · Boise, IDBuilt 2013 · S/N 5961 N903EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7621 N904EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7628 N904FJSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 15004 N905EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7632

Back to AD 2007-07-07 R1