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.

N228PQDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15228 N228PSSkywest Airlines Inc · St George, UTS/N 7897 N232PQDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15232 N239LHAerovision Aircraft Services LLC · Muskegon, MIS/N 10039 N242LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 15076 N244LRSkywest Airlines Inc · St George, UTBuilt 2009 · S/N 15233 N245LRSkywest Airlines Inc · St George, UTBuilt 2009 · S/N 15234 N246LRSkywest Airlines Inc · St George, UTBuilt 2009 · S/N 15239 N246PSSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 7920 N247LRSkywest Airlines Inc · Saint George, UTBuilt 2011 · S/N 15273 N248LRSkywest Airlines Inc · St George, UTBuilt 2011 · S/N 15274 N249LRSkywest Airlines Inc · St George, UTBuilt 2011 · S/N 15275 N258PSCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2004 · S/N 7941 N266AVBank Of Utah Trustee · Salt Lake City, UTS/N 7172 N269ZRCerulean 1 LLC · Wilmington, DEBuilt 2007 · S/N 8079 N27173Wells Fargo Trust Co Na Trustee · Salt Lake City, UTS/N 7173 N272PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15272 N274AVBank Of Utah Trustee · Salt Lake City, UTS/N 7083 N279PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15279 N27EVBank Of Utah Trustee · Salt Lake City, UTS/N 7966 N28CGCorning Inc · Corning, NYBuilt 2007 · S/N 8078 N290SASlate 290 LLC · Johnstown, PABuilt 1998 · S/N 7274 N292PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15292 N293PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15293 N294PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15294 N295PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15295 N296PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15296 N297PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15297 N298PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15298 N299PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15299 N300PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15300 N301PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15301 N302PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15302 N303PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15303 N304PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15304 N305PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15305 N306PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15306 N307PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15307 N308PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15308 N309PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15309 N310PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15310 N311PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15311 N313PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15313 N314PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15314 N315PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15315 N316PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15316 N317CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10055 N319PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15319 N320PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15320 N321EACrj Capital Corp · Miami, FLBuilt 2001 · S/N 7478

Back to AD 2011-21-07 R1