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.

N530XTBank Of Utah Trustee · Salt Lake City, UTS/N 4931 N531ASAlaska Airlines Inc · Seattle, WABuilt 2010 · S/N 35199 N531JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1650 N532ASAlaska Airlines Inc · Seatac, WABuilt 2010 · S/N 36346 N533ASAlaska Airlines Inc · Seatac, WABuilt 2011 · S/N 35201 N534ASAlaska Airlines Inc · Seatac, WABuilt 2011 · S/N 35202 N534BESkytroopers LLC · Dover, DES/N 4932 N534JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1705 N534LAChirihue Leasing Trust · Wilmington, DEBuilt 2001 · S/N 32572 N535ASAlaska Airlines Inc · Seattle, WABuilt 2011 · S/N 35200 N535JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1739 N536ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 35203 N536AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5360 N536JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1784 N536LAChirihue Leasing Trust · Wilmington, DEBuilt 2001 · S/N 32573 N537ASAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 35204 N537CAAc Spe 10 LLC · Orlando, FLBuilt 2004 · S/N 33749 N537JTJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1785 N538ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 41188 N538AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 5398 N538LAQuetro Aircraft Leasing Trust · Wilmington, DEBuilt 2006 · S/N 34628 N53993United States Government · Fort Belvoir, VAFirst renewal noticeBuilt 1985 · S/N 104 N539ARBank Of Utah Trustee · Salt Lake City, UTS/N 539 N539USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26486 N53KWWiley Bob Inc Trustee · Troy, ALS/N 028 N540EALastra Air Cargo Express · Saint Petersburg, FLS/N 174 N540LACaiquen Leasing LLC · Wilmington, DEBuilt 2006 · S/N 35229 N540USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26487 N541AVSierra Nevada Company LLC · Sparks, NVBuilt 2000 · S/N 541 N541USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26488 N54241United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28953 N542KDAtares Funding LLC · Fisher Island, FLBuilt 1994 · S/N 48542 N542LAQuetro Aircraft Leasing Trust · Wilmington, DEBuilt 2008 · S/N 34629 N542USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26489 N543JNAtares Funding LLC · Fisher Island, FLBuilt 1994 · S/N 48543 N543USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26490 N544USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26491 N545JNAtares Funding LLC · Miami Beach, FLBuilt 1995 · S/N 48545 N545USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26492 N546ASAlaska Airlines Inc · Seattle, WABuilt 2005 · S/N 30022 N546JNAtares Funding LLC · Fisher Island, FLBuilt 1995 · S/N 48546 N54711United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28782 N547JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1849 N547USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26494 N548ASAlaska Airlines Inc · Seattle, WABuilt 2005 · S/N 30020 N548USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26495 N549USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26496 N550JFTs Aviation LLC · New York, NYBuilt 1985 · S/N 472 N550NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26497 N551ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34593

Back to AD 74-08-09 R2