OpenAirDocs.org
AD 2007-12-13

Registered aircraft · 140

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

N695TKNorthwest Passage LLC · Anchorage, AKS/N 920N723DRCopper Valley Air Service LLC · Glennallen, AKBuilt 1964 · S/N 1546N726FHEmerald Air Service Inc · Homer, AKS/N 124N72TTTarmac Turbo LLC · Issaquah, WABuilt 1956 · S/N 912N733PFMaster Aviation LLC · Brooklyn Park, MNBuilt 1952 · S/N 274 (1088)N734QElijah Air LLC · Bethel, AKBuilt 1958 · S/N 1395N774AERainbow Bay Resorts LLC · Nashville, TNBuilt 1955 · S/N 793N777TWilson Thomas Henry III · Anchorage, AKBuilt 1954 · S/N 859N77MVMeydenbauer Air LLC · Bellevue, WABuilt 1957 · S/N 1273 (57-6168)N791PWN791pw LLC · Anchorage, AKBuilt 1955 · S/N 791N7925Alaska Aviation Adventures LLC · Anchorage, AKBuilt 1954 · S/N 736N8134GPerrycook Flight Services LLC · Gig Harbor, WABuilt 1959 · S/N 1410N8190YRapids Camp Lodge Inc · King Salmon, AKBuilt 1955 · S/N 824N83VRRegistered aircraftS/N 1613N860BLOrcas Aircraft LLC · Orcas, WABuilt 1953 · S/N 575N8820Gooding Lake Aviation LLC · Wasilla, AKBuilt 1952 · S/N 406N888BHLdg Beaver LLC · Murrells Inlet, SCBuilt 1951 · S/N 110N900KAKenmore Air Harbor LLC · Kenmore, WABuilt 1967 · S/N 1676N904AKUsda Forest Service Fepp · Palmer, AKBuilt 1958 · S/N 1266N907BSFluckey Gary T · Homer, AKBuilt 1959 · S/N 1293N907KWWattum Investments LLC · Kodiak, AKBuilt 1968 · S/N 1691TB59N907TRYr Aircraft Leasing LLC · Bethel, AKBuilt 1961 · S/N 1476N908JMRegistered aircraftBuilt 1959 · S/N 1380N911WTikchik Airventures LLC · Dillingham, AKS/N 616N913APKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1955 · S/N 899N917WGAmphib Air LLC · Fort Myers, FLBuilt 1965 · S/N 1586TB8N927RKRegistration Pending · Roseburg, ORRegistration pendingBuilt 1956 · S/N 1012N92AKAlaska Ultimate Safaris LLC · Homer, AKBuilt 1956 · S/N 1031N93DGAircraft Marketing & Leasing LLC · Fairbanks, AKBuilt 1953 · S/N 601N93EZvi LLC · Anchorage, AKBuilt 1956 · S/N 1149N94DNRegistration Pending · Twin Falls, IDRegistration pendingBuilt 1966 · S/N 1632TB18N95DGIntricate Bay Operating LLC · Saylorsburg, PABuilt 1954 · S/N 572N963DHDehavilland LLC · Boston, MABuilt 1963 · S/N 1519N967TBJc Air Montana LLC · Missoula, MTBuilt 1967 · S/N 1669TB39N96DGAircraft Marketing & Leasing LLC · Fairbanks, AKBuilt 1954 · S/N 702N97TBNorth Atlantic Air Services LLC · Arundel, MEBuilt 1966 · S/N 1655TB31N985DHMountain Beaver LLC · Helena, MTS/N 1595N985P985p LLC · Seattle, WABuilt 1966 · S/N 1624N995SPLightning Leasing LLC · Anchorage, AKBuilt 1956 · S/N 995N9RWRainbow River Lodge Aviation LLC · Sandy, UTS/N 1095
Back to AD 2007-12-13