Skip to content

Registered aircraft · 72,007

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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N28831Stewart William G · Thousand Oaks, CABuilt 1978 · S/N AA5B0842 N28834Vogel Victor H Trustee · Loveland, OHBuilt 1978 · S/N AA5B0844 N28838Giuffre Matthew S · The Villages, FLBuilt 1978 · S/N AA5B0726 N28839Turgeon Douglas · Anderson, SCBuilt 1978 · S/N AA5B0846 N2883TGolembiewski William · Hookstown, PABuilt 1972 · S/N 28-7225265 N2883XRamano Raymond C · Napa, CABuilt 1967 · S/N 17700283 N2883ZFoster Gary E · Kress, TXBuilt 1959 · S/N 18-7045 N28842Turnquest Joad · Sanford, NCBuilt 1979 · S/N 28-7916417 N28847Mayeda Ronald K · Foster City, CABuilt 1978 · S/N AA5B0851 N28848Voltz John H · Alexandria, LABuilt 1978 · S/N AA5B0852 N2884DThree Wing Flight School LLC · Stratford, CTBuilt 1979 · S/N 28-7916504 N2884MWattum Investments LLC · Kodiak, AKBuilt 1977 · S/N 32-7840058 N2884PRocky Creek Jbd Inc · Boca Grande, FLBuilt 1955 · S/N 18-4481 N2884TBonner John A · Riverside, CABuilt 1972 · S/N 28-7225266 N2884XAngle Of Attack Flying Company LLC · Springfield, MOBuilt 1979 · S/N 28-7916511 N28852Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843732 N28854Air Devices Co LLC · Alpena, MIBuilt 1978 · S/N AA5B0861 N28856Thompson Mitchell L · Exton, PABuilt 1978 · S/N AA5B0863 N28857Sentell Charles S III · Minden, LABuilt 1978 · S/N AA5B0864 N28859Newman Richard Donald · Mercer Island, WABuilt 1978 · S/N AA5B0866 N2885DLehigh Valley Flying Club Inc · Lehigh Valley, PABuilt 1979 · S/N 28-7990520 N2885FDunkly Daniel L · Chico, CABuilt 1979 · S/N 28-7990521 N2885GWisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 28-8090001 N2885KDierkes Steven P · Henderson, NVBuilt 1979 · S/N 28-7990525 N2885PLeprechaun Air Service Inc · Syracuse, KSBuilt 1954 · S/N 18-4482 N2885QFisher Global LLC · Conway, ARBuilt 1971 · S/N 17259885 N2885RArrow Flight LLC · Springfield, VABuilt 1969 · S/N 28R-35318 N2885ZMclaughlin Paul E · Mansfield, OHS/N 374-78 N28863Koleszar John R · Lynnfield, MABuilt 1978 · S/N AA5B0870 N28865Maritime Aviation LLC · Kalispell, MTBuilt 1978 · S/N AA5B0871 N28866Marcoski Edward T · Downers Grove, ILBuilt 1978 · S/N AA5B0872 N28869Registered aircraftBuilt 1978 · S/N AA5B0874 N2886KTallman George L Jr · Ocala, FLBuilt 1979 · S/N 28-7990529 N2886PBurg Mark S · Powell Butte, ORBuilt 1955 · S/N 18-4483 N2886QWright Flyers Club Inc · Huber Heights, OHBuilt 1971 · S/N 17259886 N2886TAtkins Joseph Van · Lenoir, NCBuilt 1972 · S/N 28-7225268 N28878Alsup Patrick J · League City, TXBuilt 1978 · S/N AA5B0876 N28879Cady Eugene Roland · Port Orange, FLBuilt 1978 · S/N AA5B0877 N2887EMeeker Stanton · Squaw Valley, CABuilt 1978 · S/N 17271360 N2887PGoldberg Aviation · Cody, WYBuilt 1955 · S/N 18-4485 N2887TSanetra George W · Gary, INBuilt 1972 · S/N 28-7225269 N2887XTolmachev Nikolay A · Anchorage, AKS/N 17700287 N2887ZElliott Robert M · Sweetwater, TXBuilt 1959 · S/N 18-7060 N28881Buttery Craig B · Loxahatchee, FLBuilt 1978 · S/N AA5B0878 N28887Danos Laura S · Hampton Falls, NHBuilt 1979 · S/N 28-7990432 N2888GClark Larry K · Sedalia, COBuilt 1979 · S/N 28-7911226 N2888QChilds William C · Bridgeport, ALS/N 17259888 N2888TValenstein Glenn L · Howards Grove, WIBuilt 1972 · S/N 28R-7235153 N28890Slocum Chad W · Pleasant Grove, UTS/N 28-7990433 N28893Janzen Andrew S · Oklahoma City, OKBuilt 1978 · S/N AA5B0753

Back to AD 87-10-06 R1