Skip to content

AD 2011-21-07 R1

Registered aircraft · 910

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:2011-21-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:2011-21-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:2011-21-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:2011-21-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:2011-21-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:2011-21-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 N8891AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7891 N8894AGold Coast Aviation · Fort Lauderdale, FLS/N 7894 N8896AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7896 N889ASFrontera Flight Holdings Inc · Dover, DEBuilt 2001 · S/N 7538 N88YHSuperior Aviation Inc · Orlando, FLS/N 7738 N88YRSuperior Aviation Inc · Orlando, FLS/N 7607 N8908DSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7908 N890DDow Chemical Co · Midland, MIBuilt 2020 · S/N 15496 N890SARi Millennium I LLC · Beverly, MABuilt 2001 · S/N 7548 N8921BAm Pm Services LLC · Northbrook, ILBuilt 2004 · S/N 7921 N892DDow Chemical Co · Midland, MIBuilt 2021 · S/N 15497 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 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 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 N896SKSkywest Airlines Inc · St George, UTBuilt 2006 · S/N 15102 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 N897SKSkywest Airlines Inc · St George, UTBuilt 2006 · S/N 15103 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 N898SKSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15110 N899SKSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15112 N900EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7608 N901EVSkywest Airlines Inc · Saint George, UTBuilt 2002 · S/N 7616 N901XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15130 N902EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7620 N902FJSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 15002 N902XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15131 N903EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7621 N903XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15134 N904EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7628 N904FJSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 15004 N904XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15135 N905EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7632 N905XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15137 N906EVSkywest Airlines Inc · St George, UTS/N 7642 N906FJSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 15006

Back to AD 2011-21-07 R1