Skip to content

Registered aircraft · 1,051

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

N100PCSmokey Bay Air Inc · Homer, AKBuilt 1978 · S/N 20700467 N101ALRegistered aircraftBuilt 1980 · S/N U20605684 N101EEAlaskan Aerial Photography LLC · Anchorage, AKBuilt 1982 · S/N U20606602 N1020VCraig Air Inc · Wasilla, AKBuilt 1974 · S/N U20602404 N102BNDelta State University · Cleveland, MSBuilt 1978 · S/N U20604268 N1031VIntelinair Geospatial LLC · Indianapolis, INBuilt 1974 · S/N U20602409 N103RAArizone Game And Fish Dept · Phoenix, AZS/N U20605995 N1046VSusitna Air Service LLC · Anchorage, AKBuilt 1974 · S/N U20602418 N104KJb Aircraft LLC · Anchorage, AKBuilt 1969 · S/N 20700122 N1051VSackett Ryan W · Anchorage, AKBuilt 1974 · S/N U20602421 N1061PRemote Properties LLC · Anchorage, AKBuilt 1983 · S/N U20606773 N1065VRegistered aircraftBuilt 1974 · S/N U20602435 N107JPPayne Thomas E · Old Forge, NYBuilt 1973 · S/N U20602079 N1083VWoltering Myron B · Granite Bay, CABuilt 1974 · S/N U20602453 N109RCLentfer Clinton H A · Anchorage, AKBuilt 1974 · S/N U20602616 N109RSUnited States Department Of Interior · Boise, IDS/N U20606002 N109SWChugiak Aviation Leasing LLC · Chugiak, AKBuilt 1977 · S/N U20603799 N10DCHbk LLC · Lynden, WAS/N U206-05366 N110NJState Of New Jersey · Trenton, NJBuilt 1986 · S/N U20606938 N111ZUsda Forest Service · Boise, IDS/N U20602919 N1120VKodiak Marine Construction · Oakley, IDBuilt 1976 · S/N U20603130 N113AGOrban Cedric · Coral Springs, FLBuilt 1977 · S/N U20603750 N114AGRlc Aviation LLC · Ansted, WVBuilt 1979 · S/N U20604674 N1157QRrc Inc · Madison, MSBuilt 1975 · S/N U20602848 N1158ZMoffitt Carl A · Orange, CAS/N U20606634 N115EL182 Flight Corp · Bronx, NYBuilt 1984 · S/N U20606814 N1191QCameron Schoessler Aviation LLC · Bliss, IDBuilt 1975 · S/N U20602862 N1191VWilmarth Rebecca C · Red Devil, AKBuilt 1974 · S/N U20602506 N1194QKirkpatrick Jason · Mosca, COBuilt 1975 · S/N U20602864 N120JHC&C Cessna LLC · Baltimore, MDBuilt 1977 · S/N U20603636 N121LLWild Blue Air LLC · Homer, AKBuilt 1977 · S/N U20603756 N1220GGastrock Robert C Trustee · Anchorage, AKBuilt 1973 · S/N U20602232 N123TMJaars Inc · Waxhaw, NCS/N U20601768 N124WHHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1979 · S/N U20605355 N124WNTemple Steve D · Superior, MTBuilt 1972 · S/N U206-01832 N1255VHanson Lanny Lane · Polson, MTBuilt 1974 · S/N U20602540 N128TTWarner Wings LLC · Yakima, WABuilt 1979 · S/N U20604991 N129ELTrooien-Smith Construction LLC · Seeley Lake, MTBuilt 1978 · S/N U20604374 N12AWTgam LLC · Toppenish, WABuilt 1978 · S/N U20604688 N12DUWoodtick Summit Aviation LLC · Redmond, ORBuilt 1979 · S/N U20605202 N1301LFox Aircraft LLC · Bethel, AKBuilt 1980 · S/N 20700641 N131TTCharlie Kilo Enterprises Inc · Melbourne, FLBuilt 1979 · S/N U20605010 N134RFMaverick Jet Leasing Inc · Wilmington, DES/N U20602719 N1361VLeduc Richard · Mazama, WABuilt 1974 · S/N U20602584 N1372VBoland Matthew S · Anchorage, AKS/N U20602588 N1454QDarden Tyson · Wasilla, AKS/N U20602900 N145PLState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606141 N147TXTexas Department Of Transportation · Austin, TXBuilt 1979 · S/N U20604987 N14NNAms Aviation LLC · South Bend, INBuilt 1980 · S/N U20605374 N1503UAmerican Jet Center Inc · Chino, CABuilt 1973 · S/N U20602228

Back to AD 85-17-07