Registered aircraft · 4,274

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:2009-21-10-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:2009-21-10-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:2009-21-10-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:2009-21-10-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:2009-21-10-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:2009-21-10-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.

N565JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2031 N565RVCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1997 · S/N 1323 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 N567AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4567 N567CACascade Spares Inc · Knoxville, TNBuilt 1991 · S/N 24608 N567UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5728 N56859United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32818 N5689TT2 Aviation LLC · Sheridan, WYBuilt 2000 · S/N 1419 N568ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35183 N568JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2063 N568LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 42214 N568UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5751 N569ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35184 N569AZAmazon.Com Services LLC · Seattle, WAS/N 25246 N569CAAc Spe 11 LLC · Orlando, FLS/N 30763 N569JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2075 N56LK2 Investment Fund LLC · Zephyr Cove, NVBuilt 1993 · S/N 1213 N57016United Airlines Inc · Chicago, ILBuilt 2000 · S/N 28679 N570ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35185 N570DCWebster Air LLC · Houston, TXBuilt 1992 · S/N 1185 N570JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2099 N570LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 40799 N570TABank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 3869 N57111United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27301 N571ASUmb Bank Na Trustee · Salt Lake City, UTS/N 32904 N571AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30388 N571JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2125 N572AA727x Aerospace Corp · Lewes, DES/N 49458 N572FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 48755 N572LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 41747 N572UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5899 N573AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53092 N573FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 48769 N573UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5939 N57439United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33534 N574AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53151 N574FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 48499 N575FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48500 N575UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5980 N576AAFronteraflight Holdings Inc · Dover, DES/N 53153 N576FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48501 N576UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6027 N577ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35186 N577NANasa Langley Research Center · Hampton, VAS/N 32892 N57852United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32811 N57855United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32814 N57857United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32816

Back to AD 2009-21-10 R1