Skip to content

Registered aircraft · 2,912

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.

N286FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63139 N286GBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 26245 N286NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4447 N286UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48453 N287FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63138 N287KBCsds Asset Management LLC · Marana, AZBuilt 1987 · S/N 49768 N287NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4508 N287UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 48539 N288FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63137 N288NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4537 N288UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48540 N289FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63136 N289GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 3016 N289MTRaytheon Co · Ontario, CABuilt 1981 · S/N 22467 N289NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2011 · S/N 4574 N289UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48455 N290CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40564 N290FAUmb Bank N A Trustee · Salt Lake City, UTS/N 29080 N290FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63135 N290NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2191 N290UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48456 N290XCMojave Jet LLC · Wilmington, DES/N 290 N29124United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27565 N29129United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28969 N291EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53039 N291FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63134 N291GXGlobal Crossing Airlines Inc · Miami, FLBuilt 2007 · S/N 3349 N291NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2206 N291UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48477 N292EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53208 N292FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63133 N292NVBank Of Utah Trustee · Salt Lake City, UTS/N 4891 N292UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 48566 N293EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53209 N293FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63132 N293NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4913 N293UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48473 N294EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53210 N294FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63131 N294NVBank Of Utah Trustee · Salt Lake City, UTS/N 4941 N294TLAviation Inventory Resources Inc · Alvarado, TXBuilt 1997 · S/N 340B-294 N294UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48472 N295EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53211 N295FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63130 N295NVBank Of Utah Trustee · Salt Lake City, UTS/N 4942 N296EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53212 N296FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64056 N296NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2674 N29717United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28936 N297EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53213

Back to AD 74-08-09 R2