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.

N324PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15324 N325PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15325 N326MSSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15124 N326PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15326 N329MSSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15126 N329PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15329 N330PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15330 N331CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10061 N331PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15331 N335MSWells Fargo Trust Co Na Trustee · Salt Lake City, UTS/N 7247 N335PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15335 N336PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15336 N337PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15337 N340CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10062 N341PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15341 N348PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 15348 N349PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 15349 N354CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10064 N355CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10067 N365SLN702sj LLC · Scottsdale, AZBuilt 2001 · S/N 7489 N367CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10069 N368CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10075 N37178Bank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 7178 N371CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10082 N376CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10092 N379CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10102 N384CRBank Of Utah Trustee · Salt Lake City, UTS/N 7384 N38CGCorning Inc · Corning, NYBuilt 2008 · S/N 8088 N390CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10106 N391CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10108 N396SAMard Aviation LLC · Johnstown, PABuilt 2003 · S/N 7839 N398CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10112 N405AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 1999 · S/N 7362 N407SWBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 7034 N408AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2001 · S/N 7568 N409AWCsi Aviation Inc · Killeen, TXBuilt 2000 · S/N 7447 N410AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2001 · S/N 7490 N411ZWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 7569 N412AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2001 · S/N 7582 N413AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2001 · S/N 7585 N413SWBank Of Utah Trustee · Salt Lake City, UTBuilt 1996 · S/N 7102 N414ZWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2001 · S/N 7586 N415AWCsi Aviation Inc · Killeen, TXBuilt 2001 · S/N 7593 N416AWCsi Aviation LLC · Killeen, TXBuilt 2002 · S/N 7603 N417AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2002 · S/N 7610 N417NLBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 8110 N419AVBank Of Utah Trustee · Salt Lake City, UTS/N 7419 N419AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2002 · S/N 7633 N420AWCsi Aviation Inc · Killeen, TXBuilt 2002 · S/N 7640 N421ZWAir Wisconsin Airlines LLC · Appleton, WIBuilt 1999 · S/N 7346

Back to AD 2011-21-07 R1