OpenAirDocs.org
AD 2004-05-01 R1

Registered aircraft · 76

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
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:2004-05-01-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:2004-05-01-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.

N100BWTalkeetna Air Taxi Inc · Talkeetna, AKBuilt 1954 · S/N 58N1018BSummit Leasing LLC · Kenai, AKBuilt 1960 · S/N 392N104BMPorter Jeanne G · Homer, AKBuilt 1956 · S/N 118N116TLTordrillo Mountain Aviation LLC · New York, NYBuilt 1956 · S/N 174N125KDJb Leasing Co LLC · Kenai, AKBuilt 1962 · S/N 436N142JBAlaska Remote Outfitters LLC · Kenai, AKBuilt 1956 · S/N 74N150BAKenai River Xpress LLC · Soldotna, AKBuilt 1953 · S/N 15N17689Rjf Holdings LLC · Rcho Sta Marg, CABuilt 1961 · S/N 431N205RCTalkeetna Air Taxi Inc · Talkeetna, AKS/N 201N226UTOtters R US LLC · Chitina, AKBuilt 1957 · S/N 226N252TATalon Air Service Inc · Soldotna, AKBuilt 1958 · S/N 252N254AWDestination Alaska Air Service LLC · Homer, AKBuilt 1957 · S/N 254N2899JRustair Inc · Anchorage, AKBuilt 1961 · S/N 425N292PMSingle Otter Leasing Two LLC · Ketchikan, AKS/N 292N2YVTalkeetna Air Taxi Inc · Talkeetna, AKBuilt 1957 · S/N 207N3125NKatmai Air LLC · Anchorage, AKBuilt 1960 · S/N 394N3125SMountain Pt Leasing LLC · Ketchikan, AKBuilt 1960 · S/N 407N320KTRustair Inc · Anchorage, AKBuilt 1956 · S/N 73N3324TBlue Aircraft LLC · Ketchikan, AKBuilt 1957 · S/N 205N336AKDh Leasing LLC · Juneau, AKBuilt 1958 · S/N 333N337AKDh Leasing LLC · Juneau, AKBuilt 1961 · S/N 418N338AKDh Leasing LLC · Juneau, AKBuilt 1958 · S/N 262N339AKDh Leasing LLC · Juneau, AKBuilt 1965 · S/N 454N379PMSingle Otter Leasing LLC · Ketchikan, AKBuilt 1961 · S/N 379N413JPBald Mountain Air Service Inc · Homer, AKBuilt 1958 · S/N 314N424KTRustair Inc · Anchorage, AKBuilt 1958 · S/N 338N435BSingle Otter Leasing LLC · Ketchikan, AKBuilt 1956 · S/N 183N43SPSamaritans Purse · Boone, NCBuilt 1956 · S/N 140N443CBKatmai Air LLC · Anchorage, AKBuilt 1960 · S/N 387N4899RRustair Inc · Anchorage, AKBuilt 1960 · S/N 353N491KKatmai Air LLC · Anchorage, AKBuilt 1962 · S/N 434N49AWSummit Leasing LLC · Kenai, AKBuilt 1958 · S/N 310N50KAKenmore Air Harbor LLC · Kenmore, WABuilt 1956 · S/N 221N510PRTalkeetna Air Taxi Inc · Talkeetna, AKS/N 250N51441Sunset Holdings LLC · Ketchikan, AKBuilt 1960 · S/N 409N528SWMountain Pt Leasing LLC · Ketchikan, AKS/N 28N5322GDarden Tyson B · Wasilla, AKS/N 128N560TRJespersen Aircraft Services Inc · Bettles Field, AKBuilt 1956 · S/N 141N562494 Star Aviation Inc · Jefferson City, MOS/N 4656N565TATalkeetna Air Taxi Inc · Talkeetna, AKBuilt 1954 · S/N 46N58JHKenmore Air Harbor LLC · Kenmore, WAS/N 131N606KAKenmore Air Harbor LLC · Kenmore, WABuilt 1954 · S/N 37N6281Jb Leasing Company LLC · Kenai, AKS/N 376N63354Red Leasing LLC · Juneau, AKBuilt 1953 · S/N 30N636KTRustair Inc · Anchorage, AKS/N 451N6868BDoyon Air Transport LLC · Ketchikan, AKBuilt 1958 · S/N 274N702KAKenmore Air Harbor LLC · Kenmore, WABuilt 1954 · S/N 54N703THMunich Hans W DBA · Yakutat, AKBuilt 1966 · S/N 456N707KAKenmore Air Harbor LLC · Kenmore, WAS/N 106N708KAJb Leasing Company LLC · Kenai, AKBuilt 1954 · S/N 59
Back to AD 2004-05-01 R1