Skip to content

AD 2003-03-15 R1

Registered aircraft · 368

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:2003-03-15-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:2003-03-15-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:2003-03-15-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:2003-03-15-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:2003-03-15-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:2003-03-15-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.

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 N120JMSouth Aircraft Leasing Inc · Wilmington, DEBuilt 1988 · S/N 48311 N127NKPerris Valley Airport Inc · Perris, CAS/N 47361 N129TWLogistic Air Inc · Reno, NVBuilt 1976 · S/N 21141 N141WEOmega Air Inc · San Antonio, TXS/N 46661 N149XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1993 · S/N 27149 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 N17085Bc Aircraft Leasing LLC · Albuquerque, NMBuilt 1975 · S/N 47957 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 N225PGAero 7 LLC · Doral, FLS/N 25247 N235ULAircraft Endeavors LLC · San Antonio, TXBuilt 1976 · S/N 46956 N24089Ploutz Lloyd · Modesto, CAS/N 20455 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 N253GCAerway Capital Management LLC · Waterford, WIS/N 25303 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 N263LMVent Airlines Inc · Dover, DEBuilt 1994 · S/N 26603 N263UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 48782 N264DEAircraft Endeavors LLC · San Antonio, TXBuilt 1978 · S/N 46985 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 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 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

Back to AD 2003-03-15 R1