Skip to content

Registered aircraft · 2,914

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:74-08-09-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-09-R2') 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:74-08-09-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-09-R2')
  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:74-08-09-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-09-R2')
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.

N551NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26498 N552ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34595 N552JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1861 N552NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26499 N553AAFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 53083 N553ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34594 N553NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26500 N554JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1898 N554NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26501 N554WTAerownership North American Services Inc Trustee · Dover, DES/N 28554 N555DWInstitue Of Aeronautical And Aerospace Institute · Aguadilla, PRBuilt 1985 · S/N 459 N555NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 33391 N555SQTatonduk Outfitters Ltd · Fairbanks, AKBuilt 1957 · S/N 45137 N556AAFrontera Flight Holding Inc · Dover, DEBuilt 1991 · S/N 53086 N556ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35175 N556JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1904 N556NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 33392 N556PM645 Aeronautical Systems Group (Aesg) · Wpafb, OHBuilt 1996 · S/N 413 N557ANPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53087 N557ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35176 N557NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 33393 N558AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53088 N558ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35177 N558JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1915 N559ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35178 N559JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 1917 N560AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53090 N560ASAlaska Airlines Inc · Seatac, WABuilt 2006 · S/N 35179 N560WKBank Of Utah Trustee · Salt Lake City, UTS/N 560 N561AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53091 N561JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1927 N562ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35091 N562AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5622 N562JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1948 N563ASAlaska Airlines Inc · Seatac, WABuilt 2006 · S/N 35180 N563AWUS Department Of State · Melbourne, FLS/N 563 N563JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2006 N563WNWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N 34296 N564ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35103 N564JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2020 N564LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 40593 N565ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35181 N565JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2031 N566AAFrontera Flight Holding Inc · Dover, DEBuilt 1987 · S/N 49348 N566ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35182 N566JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2042 N566LAJilguero Owner Trust · Wilmington, DEBuilt 2011 · S/N 40798 N566PTPriority Air Charter LLC · Kidron, OHBuilt 1944 · S/N 13346 N567AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4567 N567CACascade Spares Inc · Knoxville, TNBuilt 1991 · S/N 24608

Back to AD 74-08-09 R2