Registered aircraft · 5,439

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:95-26-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:95-26-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:95-26-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:95-26-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:95-26-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:95-26-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.

N117UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1224 N118AXAlaska Central Express Inc · Anchorage, AKBuilt 1990 · S/N UC116 N118BHBighorn Airways Inc · Sheridan, WYBuilt 1975 · S/N 340A0003 N118DYDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10140 N118MDAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-118 N118NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6162 N118USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1264 N119ABSafford Aviation Service Inc · Coolidge, AZBuilt 1966 · S/N TE-145 N119AFAviation Sales Associates LLC · Costa Mesa, CABuilt 2002 · S/N 1489 N119AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC-43 N119DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10182 N119FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64057 N119FMOceanside Aviation LLC · Santa Monica, CABuilt 2001 · S/N 1464 N119NAUnited States Government · Washington, DCBuilt 1989 · S/N 24487 N119NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6222 N119USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1268 N11ACN11ac LLC · Lighthouse Point, FLS/N TC-215 N11JARegistration Pending · Denison, TXRegistration pendingBuilt 1977 · S/N 340A0292 N11KFRebel Dawg Aviation LLC · Vestavia Hills, ALBuilt 1967 · S/N TE-325 N11SCHarrington John M · Payson, AZBuilt 1958 · S/N TD-141 N11SYRautiola Erik · Cresson, TXS/N TC-1468 N11VKHoskins Terry Wayne II · Knoxville, TNBuilt 1961 · S/N TC-200 N11VNHilton Head Flyers LLC · Liberty, SCBuilt 1981 · S/N ME-416 N1200KDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28457 N1201PDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28458 N1202BDavis Aviation Inc DBA · Brandon, MSBuilt 1974 · S/N TC1825 N1208ZMaurice L Prince Jr Pc · Lafayette, LABuilt 1961 · S/N TC-60 N120BSkysuite Aviation LLC · Tujunga, CABuilt 1962 · S/N TC-230 N120DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10185 N120EEUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6227 N120HAAstley Mark C · Wayne, NJBuilt 1977 · S/N 340A0295 N120HL4e Holdings LLC · Milwaukee, WIBuilt 1988 · S/N 120.111 N120JJAviation Sales Associates LLC · Costa Mesa, CABuilt 1995 · S/N 1264 N120SBHrs Aircraft LLC · New York, NYBuilt 2001 · S/N 1462 N120UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 29166 N120UCAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC120 N120UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0805 N120WJFly Vulture Aviation LLC · Southwest Ranches, FLS/N 1004 N12109United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27299 N12114United Airlines Inc · Chicago, ILBuilt 1995 · S/N 27556 N12116United Airlines Inc · Chicago, ILBuilt 1996 · S/N 27558 N12125United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28967 N1215TShepphird John C · Reno, NVBuilt 1966 · S/N TE-102 N1217AAndromeda Leasing I LLC · Purchase, NYBuilt 1992 · S/N 25865 N121ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6238 N121APCrossland Global Sky LLC · Rogers, ARBuilt 1994 · S/N 1239 N121BWLester Jon M · Lancaster, OHBuilt 1979 · S/N TC-2256 N121CBClark Andrew R · Woodside, CABuilt 1976 · S/N 340A0087 N121CZN121cz LLC · Milwaukee, WIBuilt 1999 · S/N 120350 N121DZDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10233

Back to AD 95-26-15 R1