Skip to content

Registered aircraft · 10,639

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:99-01-05-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:99-01-05-R1') 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:99-01-05-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:99-01-05-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.

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:99-01-05-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:99-01-05-R1')
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.

N82946Class A Coaches LLC · Missoula, MTBuilt 1977 · S/N 18-7809030 N82947Mann Jacob A · Wheatland, WYBuilt 1978 · S/N 18-7909032 N82949Mcbride Peter M · Basalt, COBuilt 1978 · S/N 18-7909033 N8294CZink Jason A · Belfair, WABuilt 1954 · S/N 22-2359 N82951Av Enterprises Inc · Bozeman, MTBuilt 1978 · S/N 18-7909035 N82956Holmes James E · Klamath Falls, ORBuilt 1979 · S/N 18-7909034 N82961Montgomery Daniel G · Wasilla, AKBuilt 1978 · S/N 18-7909036 N82962Jacques Jerry J · Iliamna, AKS/N 18-7909037 N82968Pulse Jeremy D · Moore, MTS/N 18-7909040 N82969Feriani Ralph B · Anchorage, AKBuilt 1978 · S/N 18-7909041 N82972Supercub LLC · Anchorage, AKBuilt 1977 · S/N 18-7809001 N82976Wrathall Grant R Jr Trustee · Wasilla, AKBuilt 1977 · S/N 18-7809002 N82977Bump Jennifer P · King Salmon, AKBuilt 1977 · S/N 18-7809003 N8297CSullivan Timothy K · Portage, MIBuilt 1954 · S/N 22-2362 N82980Grier Timothy R · Anchorage, AKBuilt 1977 · S/N 18-7809004 N82981Dennis Ray A · Mills, WYBuilt 1977 · S/N 18-7809006 N82982Stone Robert D · Anchorage, AKBuilt 1951 · S/N 18-620 N82983Stone Robert D · Anchorage, AKBuilt 1977 · S/N 18-7809008 N82985Petro Jerry R · Williamsburg, VABuilt 1977 · S/N 18-7809009 N82986Bunger V George L · Ozona, TXBuilt 1977 · S/N 18-7809010 N82990Lavigne Bruce G · Ranier, MNBuilt 1977 · S/N 18-7809012 N82999Dagostino Thomas J · Wasilla, AKBuilt 1978 · S/N 18-7809014 N829AHochstatter Patrick J · Moses Lake, WABuilt 1951 · S/N 22-131 N8301PMann Herbert A · Soldotna, AKBuilt 1963 · S/N 18-8040 N830MDMcelwee Glenda A · Lake City, FLS/N 22-6590 N8315MBurcin Michael H · Washington, PABuilt 2004 · S/N CU 18-001 N831APlane Fun Inc Tr Trustee · Snellville, GABuilt 1951 · S/N 22-132 N8324Veal Tim S · Egegik, AKBuilt 1953 · S/N 18-2377 N83268Wright Kim B · Bozeman, MTS/N 18-7609057 N83271Nohrenberg Raymond C · Pingree, NDS/N 18-7609061 N83272Bowker James D · Willow, AKBuilt 1976 · S/N 18-7609063 N83275Perry Scott D · Hood River, ORBuilt 1976 · S/N 18-7609062 N83278Hamlin Andrew J · Two Rivers, AKBuilt 1976 · S/N 18-7709047 N83281Chandler Air Service Inc · Chandler, AZBuilt 1976 · S/N 18-7609064 N83283Hayton James B · Sedro Woolley, WABuilt 1976 · S/N 18-7609065 N83285Dyches Abigail · Eagle River, AKBuilt 1976 · S/N 18-7609067 N8329649 Ranch Co LLC · Odonnell, TXBuilt 1976 · S/N 18-7609068 N83299Brewer Danny E Jr · Nikiski, AKBuilt 1976 · S/N 18-7609070 N832ABeck John Edward · Newton, IABuilt 1951 · S/N 22-133 N83310Hankerd William J · Port Alsworth, AKBuilt 1976 · S/N 18-7609072 N83312Meggers Roger D · Baker, MTBuilt 1976 · S/N 18-7609074 N83316Meggers Roger D · Baker, MTBuilt 1976 · S/N 18-7609075 N83324Innovations Educational Consulting Inc · Eden, UTBuilt 1976 · S/N 18-7609076 N83325Usda Aphis Wildlife Services · Cedar City, UTBuilt 1976 · S/N 18-7609078 N83326Gaston Gerald M · Bozeman, MTBuilt 1976 · S/N 18-7609077 N83328Fogg Peter T · Holden, MEBuilt 1976 · S/N 18-7609079 N83330Olson Jerry W · Seward, AKBuilt 1976 · S/N 18-7609080 N83332Adamson Todd M · Cody, NEBuilt 1976 · S/N 18-7709050 N83335Peters Nancy A Trustee · Corning, MOBuilt 1976 · S/N 18-7609085 N83337Hubbell Wallis E · Federal Way, WABuilt 1976 · S/N 18-7609084

Back to AD 99-01-05 R1