Skip to content

Registered aircraft · 554

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:86-11-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:86-11-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:86-11-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:86-11-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:86-11-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:86-11-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.

N101ALRegistered aircraftBuilt 1980 · S/N U20605684 N101EEAlaskan Aerial Photography LLC · Anchorage, AKBuilt 1982 · S/N U20606602 N102BNDelta State University · Cleveland, MSBuilt 1978 · S/N U20604268 N103RAArizone Game And Fish Dept · Phoenix, AZS/N U20605995 N1061PRemote Properties LLC · Anchorage, AKBuilt 1983 · S/N U20606773 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 N113AGOrban Cedric · Coral Springs, FLBuilt 1977 · S/N U20603750 N114AGRlc Aviation LLC · Ansted, WVBuilt 1979 · S/N U20604674 N1158ZMoffitt Carl A · Orange, CAS/N U20606634 N115EL182 Flight Corp · Bronx, NYBuilt 1984 · S/N U20606814 N120JHC&C Cessna LLC · Baltimore, MDBuilt 1977 · S/N U20603636 N121LLWild Blue Air LLC · Homer, AKBuilt 1977 · S/N U20603756 N124WHHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1979 · S/N U20605355 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 N131TTCharlie Kilo Enterprises Inc · Melbourne, FLBuilt 1979 · S/N U20605010 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 N162VPVirunga Airwing LLC · Washington, DCS/N U20606215 N166ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1986 · S/N U20606923 N168SABruchid Snodgrass LLC · Reno, NVBuilt 1981 · S/N U20606073 N16GPDeckload Aviation LLC · Kodiak, AKS/N U20604467 N1717YSeventeen Yankee LLC · Fort Lauderdale, FLBuilt 1979 · S/N U20605030 N171RSSeneque USA Inc · West Palm Beach, FLBuilt 1980 · S/N U20605558 N1723BBoyko George · Tarpon Springs, FLBuilt 1979 · S/N 206-05190 N1748RNorthstar Holdings LLC · Anchorage, AKBuilt 1980 · S/N U20605438 N1797RNorthstar Holdings LLC · Anchorage, AKBuilt 1981 · S/N U20606331 N181PKPacific Mission Aviation · Hagatna, GUS/N U20606158 N181TXAddie-Air Inc · Bridgeport, TXBuilt 1981 · S/N U20606408 N192CMFriehe Berend · Moses Lake, WABuilt 1981 · S/N U20606160 N193TATuck Aerial Surveys Inc · Big Stone Gap, VABuilt 1980 · S/N U20605946 N198AZCoyote Aviation LLC · Ballston Spa, NYBuilt 1980 · S/N U20605961 N19MJCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N U20605372 N200HPOklahoma Department Of Public Safety · Norman, OKS/N U20605693 N200QRPdq Flight Inc · Garden City, NYS/N U20606092 N204TSAs The Crow Flies Aerial Services LLC · Irving, TXBuilt 1977 · S/N U20604052 N206ARCanoe Bay Outfitters LLC · Port Alsworth, AKBuilt 1978 · S/N U20604766 N206BLWright Kim B · Anchorage, AKBuilt 1979 · S/N U20605491 N206BRWest Matthew Shawn · Island, KYBuilt 1981 · S/N U20606350 N206CTDe Creeft Joseph M · Homer, AKBuilt 1981 · S/N U206-06090 N206DP W Feenstra Construction Inc · Queen Creek, AZBuilt 1978 · S/N U20604415 N206EKKoch & Koch Inc · Grass Valley, CABuilt 1981 · S/N U20606291 N206FLRegistered aircraftBuilt 1978 · S/N U20604627 N206FMParrott David C · Harrison, MES/N U20606253

Back to AD 86-11-07