Skip to content

Registered aircraft · 40,472

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

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 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 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 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 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 N2888QChilds William C · Bridgeport, ALS/N 17259888 N28890Slocum Chad W · Pleasant Grove, UTS/N 28-7990433 N28893Janzen Andrew S · Oklahoma City, OKBuilt 1978 · S/N AA5B0753 N28896Pafford David A · Floydada, TXS/N AA5B0752 N2889XKogele Donald J · Broadus, MTBuilt 1967 · S/N 17700289 N2889ZPeters Thomas K · Wasilla, AKBuilt 1959 · S/N 18-7066 N288CFAdams Charles R · Granbury, TXBuilt 1978 · S/N AA5B0840 N288FDFly Dynasty Corp · Ocala, FLBuilt 1967 · S/N 28-23767 N288GHBowen Christina M · Shreveport, LAS/N 28-1938 N288HCLampe Erik J · Appleton, WIBuilt 1992 · S/N 10101 N288HGGeorgia Aviation Authority · Eastman, GABuilt 2002 · S/N 2842144 N288HPChaikin Steven · Kaunakakai, HIBuilt 2001 · S/N 2843482 N288MDDietl Manfred · Naples, FLBuilt 2001 · S/N 2177 N288PASkywest Leasing Inc · St George, UTBuilt 2002 · S/N 2843502 N288RSale Reported · Northfield, MASale reportedS/N 288R N288STRegistered aircraftBuilt 2005 · S/N 3763 N288WPPhillips William D · Forsyth, GAFirst renewal noticeBuilt 2011 · S/N 81808 N28907Warren Scott D · Lucerne, CABuilt 1979 · S/N 28-7990434 N2890QCarrick Christopher A · Castro Valley, CABuilt 1971 · S/N 17259890 N28917Turnage Andrew · Houston, TXBuilt 1978 · S/N AA5B0888 N2891PHula Jesse M · Anchorage, AKBuilt 1956 · S/N 18-4489 N2891TVagias Janet Rose · Niceville, FLBuilt 1972 · S/N 28-7225270

Back to AD 80-04-03 R2