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.

N343KTRustair Inc · Anchorage, AKBuilt 1965 · S/N 1623TB-14N345SSPyng LLC · Palo Alto, CABuilt 1966 · S/N 1611N36GHMustang High Flight LLC · Boise, IDBuilt 1966 · S/N 1636N375RMGrizzly Air Service Inc · Paris, TXBuilt 1952 · S/N 1227N378BDC D S Aircraft Inc · Seattle, WABuilt 1955 · S/N 806N4334YSandaris Inc Trustee · Wilmington, DEBuilt 1959 · S/N 1401N450PN450p LLC · Sumner, WABuilt 1960 · S/N 1449N454DBRegistration Pending · Round Hill, VARegistration pendingBuilt 1957 · S/N 1183N456LCHon Kinzie K · Anchorage, AKS/N 434N456SFFejes Samuel T Jr · Anchorage, AKS/N 1683 TB51N492KKatmai Air LLC · Anchorage, AKBuilt 1957 · S/N 1185N4957WAk Air Leasing LLC · Homer, AKBuilt 1959 · S/N 1385N511CMCunningham Terry · Santa Barbara, CAS/N 1627N5160GBlue Aircraft LLC · Ketchikan, AKS/N 236N522PJParlu Ventures LLC · Eagles Mere, PAS/N 86N529TBkb Aviation LLC · Helena, MTBuilt 1964 · S/N 1540N530BJPeters Gary B · Clarkston, WAS/N 530N5344GN68hm LLC · Mentor, OHS/N 1219N535PKFaster Than A Dog Sled LLC · Stanford, CABuilt 1956 · S/N 869N548GTSouthwest Associates LLC · Bigfork, MTBuilt 1967 · S/N 1685-TB53N54BBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1954 · S/N 715N557RCCollins Roger D · Woodinville, WABuilt 1957 · S/N 1060N564RCNovember564rc LLC · Kirkland, WABuilt 1957 · S/N 1156N565TMSea-Air Ltd · Aurora, ORBuilt 1956 · S/N 907N5978Fulton William James · Kodiak, AKBuilt 1951 · S/N 308N59SSMcdonald Kirby · Bellevue, WAS/N 1117N603DADestination Alaska Air Service LLC · Homer, AKBuilt 1957 · S/N 1161N60TFKalinin Partners LLC · Juneau, AKBuilt 1957 · S/N 1205N60WTTalkeetna Aviation LLC · Talkeetna, AKBuilt 1953 · S/N 491N62197Mccrea Daniel B · Waldport, ORBuilt 1957 · S/N 1177N62353Red Leasing LLC · Juneau, AKBuilt 1959 · S/N 1363N62355Ward Air Inc · Juneau, AKBuilt 1957 · S/N 1045N62357Ward Air Inc · Juneau, AKBuilt 1957 · S/N 1145N62358Red Leasing LLC · Juneau, AKBuilt 1953 · S/N 627N62DBWattum Investments LLC · Kodiak, AKBuilt 1965 · S/N 1578TB7N6464PGateway Aviation LLC · Ketchikan, AKBuilt 1952 · S/N 464N654DFFrederikson David M Trustee · Eau Claire, WIBuilt 1954 · S/N 753N6653KGorelick Kenneth B Trustee · Woodland Hills, CABuilt 1953 · S/N 565N670ABOban Holdings LLC · Deephaven, MNBuilt 1960 · S/N 1428 (1966)N67679Av8 LLC · Boise, IDBuilt 1957 · S/N 1294N67680C & P Aircraft Leasing LLC · Renton, WABuilt 1958 · S/N 1338N67681Northwest Seaplanes Inc · Renton, WAS/N 1158(56-4425)N67684C & P Aircraft Leasing LLC · Renton, WABuilt 1958 · S/N 1208N67687Haskell Corp · Bellingham, WABuilt 1959 · S/N 1359N67691Olsen Aviation Alaska Inc · Cordova, AKS/N 540N6782LSeawind Aviation Inc · Ketchikan, AKBuilt 1955 · S/N 820N67AKKruse Jeff · Fairbanks, AKBuilt 1954 · S/N 91N682AFApogee Flight Inc · Bellingham, WAS/N 1163 (56-412)N684DDPeninsula Aeroworks LLC · Fife, WABuilt 1953 · S/N 591N690John Deal LLC · Yarrow Point, WABuilt 1952 · S/N 282
Back to AD 2007-12-13