Skip to content

Registered aircraft · 2,446

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-19-13') 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-19-13') 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-19-13')
    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-19-13')
  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-19-13')
  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-19-13')
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.

N175DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24803 N175DZDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29696 N175JMKc Aviation Partners LLC · Wilmington, DES/N 28424 N176DZDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29697 N176UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1499 N177DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25122 N177DZDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29698 N177USAmerican Airlines Inc · Fort Worth, TXS/N 1517 N178DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25143 N178DZDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30596 N178USAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1519 N179DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25144 N179JMKc Aviation Partners LLC · Wilmington, DES/N 28425 N179UWWilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 1521 N180DNDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 25985 N180USWilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 1525 N181UWAmerican Airlines Inc · Fort Worth, TXS/N 1531 N18220United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28929 N18223United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28932 N18243United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28806 N182UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25279 N182UWWilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 1536 N183UWWilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 1539 N184SKBank Of Utah Trustee · Salt Lake City, UTS/N 28284 N184USAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1651 N185DNDelta Air Lines Inc · Atlanta, GABuilt 1995 · S/N 27961 N185UWAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1666 N186DNDelta Air Lines Inc · Atlanta, GABuilt 1995 · S/N 27962 N186USAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1701 N187DNDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 27582 N187USAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1704 N188DNDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 27583 N188JMKc Aviation Partners LLC · Wilmington, DES/N 32629 N188NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5669 N188USAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1724 N189DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 25990 N189NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5687 N189UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1425 N1902UUnited Airlines Inc · Chicago, ILBuilt 2006 · S/N 2714 N190DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28447 N190NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6669 N190UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1436 N1914UUnited Airlines Inc · Chicago, ILS/N 2223 N191DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28448 N191NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6704 N191UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1447 N192DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28449 N192NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6787 N192UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1496 N193DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28450

Back to AD 2007-19-13