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.

N647AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1997 · S/N 762 N647FEFederal Express Corp · Memphis, TNS/N 48798 N647NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7635 N647UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25284 N648FEFederal Express Corp · Memphis, TNS/N 48802 N648JBJetblue Airways Corp · Long Island, NYBuilt 2006 · S/N 2970 N648NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7656 N648UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25285 N649AWBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 803 N649CCBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 649 N649DLDelta Air Lines Inc · Atlanta, GABuilt 1989 · S/N 24389 N649FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 48801 N649JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2977 N649NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7679 N649UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25286 N650AWU S Bank N A Trustee · Boston, MABuilt 1998 · S/N 856 N650DLDelta Air Lines Inc · Atlanta, GABuilt 1986 · S/N 24390 N650GTUmb Bank N A Trustee · Salt Lake City, UTBuilt 1982 · S/N 22566 N650MXBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 11 N650NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7724 N651AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 866 N651BCAviation Inventory Resources Inc · Alvarado, TXS/N 340A-076 N651CEEverts Air Fuel Inc · Fairbanks, AKBuilt 1958 · S/N 45501 N651DLDelta Air Lines Inc · Atlanta, GABuilt 1989 · S/N 24391 N651JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 2992 N651NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 8018 N651UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25389 N652AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 0953 N652DLDelta Air Lines Inc · Atlanta, GABuilt 1989 · S/N 24392 N652EEAerotrust Services Corp Trustee · Wilmington, DEBuilt 1992 · S/N 26526 N652GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 1983 · S/N 22571 N652JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3029 N652NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 8021 N652UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25390 N653AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1003 N653JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3039 N653NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8012 N653UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25391 N654AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1050 N654DLDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24394 N654NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8176 N654UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25392 N655AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1075 N655DLDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24395 N655JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 3072 N655NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8376 N655UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25393 N656AWU S Bank N A Trustee · Boston, MABuilt 1999 · S/N 1079 N656GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23017 N656JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3091

Back to AD 74-08-09 R2