Skip to content

Registered aircraft · 298

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:96-02-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-02-06') 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:96-02-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-02-06')
  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:96-02-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-02-06')
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.

N10112Kc Aviation Stem Inc · Kansas City, MOS/N 193L1064 N104HRXyrec Inc · San Antonio, TXNon-citizen corporation, flight hours not reportedS/N 21525 N111REX Aviation Group LLC · Beverly Hills, CABuilt 1988 · S/N 49670 N112PSFrontera Flight Holdings Inc · Dover, DEBuilt 1967 · S/N 47013 N127NKPerris Valley Airport Inc · Perris, CAS/N 47361 N129TWLogistic Air Inc · Reno, NVBuilt 1976 · S/N 21141 N140SCOrbital Sciences LLC · Mojave, CABuilt 1974 · S/N 193E1067 N155CAHeavylift Cargo Airlines Inc · Kingman, AZS/N 46073 N158JPAerotrust Services Corp Trustee · Wilmington, DES/N 53195 N164TSBank Of Utah Trustee · Salt Lake City, UTS/N 21119 N165TSBank Of Utah Trustee · Salt Lake City, UTS/N 21523 N209TRCareer Aviation Co Inc · Wilmington, DEBuilt 1976 · S/N 20994 N213USMuseum Of Flight Foundation · Seattle, WABuilt 1969 · S/N 20213 N218JPAerotrust Services Corp Trustee · Wilmington, DES/N 53305 N24089Ploutz Lloyd · Modesto, CAS/N 20455 N248ACBank Of Utah Trustee · Salt Lake City, UTS/N E2364 N250UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48745 N251UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48744 N252UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 48768 N253UPUnited Parcel Service Co · Louisville, KYS/N 48439 N254UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 48406 N255UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48404 N256UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48405 N257UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48451 N258UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48416 N260UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48418 N261UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48805 N262UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48806 N263UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 48782 N264UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 48800 N265UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48803 N273UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 48574 N274UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 48575 N275UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48774 N276UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 48579 N277ACBank Of Utah Trustee · Salt Lake City, UTS/N E2334 N278UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48577 N2819WDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21057 N281FLInternational Trading Co Of Yukon · Oklahoma City, OKBuilt 1978 · S/N 21455 N281UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 48538 N284UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48541 N285ACBank Of Utah Trustee · Salt Lake City, UTS/N E2307 N286UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48453 N287KBCsds Asset Management LLC · Marana, AZBuilt 1987 · S/N 49768 N287UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 48539 N288UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48540 N289MTRaytheon Co · Ontario, CABuilt 1981 · S/N 22467 N289UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48455 N290UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48456 N291EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53039

Back to AD 96-02-06