Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N3207WZero Seven Whiskey LLC · Norco, CABuilt 1965 · S/N 32-7 N320827550g LLC · Birmingham, MIBuilt 1974 · S/N 28-7515065 N32089Vosberg Jeffrey A · Norwalk, IABuilt 1974 · S/N 28-7510012 N32095Rogers Dekishon W B · Atlanta, GABuilt 1974 · S/N 28-7525021 N32097Seniram Air Inc · Wilmington, DEBuilt 1975 · S/N 28-7515067 N32099Odland Steve E · Luverne, MNBuilt 1974 · S/N 28-7515068 N320NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881618 N320UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020227 N32101Speed Hunter Aviation LLC · Franklin, OHBuilt 1974 · S/N 28-7505024 N32103Freeman David B · Liberty, NCS/N 28-7505026 N32115Kowatra Anil K · Lilburn, GAFirst renewal noticeBuilt 1974 · S/N 28-7505027 N32117Stough Stephen A · Reno, NVBuilt 1974 · S/N 32-7540016 N32123Kell Matthew D · Kodiak, AKBuilt 1974 · S/N 28-7515076 N32124Howard John D · Palm Bay, FLBuilt 1974 · S/N 28-7515077 N32128David William Christy Trustee · Willis, TXBuilt 1974 · S/N 28-7505028 N32129Weaver Arnold G · Sandusky, MIS/N 28R-7535028 N3212QBrighters David E Trustee · Baton Rouge, LABuilt 1977 · S/N 28-7790443 N32139Bidzy Ta Hot Aana Corporation · Dillingham, AKFirst renewal noticeBuilt 1974 · S/N 32-7540017 N3213WElmore Terry · Berry, ALS/N 32-13 N3214WHolcombe Vell C · Hershey, PABuilt 1965 · S/N 32-15 N32151Wilson James E III · Brentwood, CAS/N 28-7505030 N32156Fier Michael A Sr · Mundelein, ILBuilt 1974 · S/N 28-7525029 N3215WDiederich Chad · Chesapeake, VABuilt 1965 · S/N 32-16 N32160Emmons Thomas M · Millington, MIBuilt 1974 · S/N 28-7525030 N32161Helseth Keith A · Kirksville, MOBuilt 1974 · S/N 28-7515082 N32165Cole Charles V · Sparta, TNBuilt 1974 · S/N 28-7515084 N32169Airleasing LLC · Beverly Hills, CABuilt 1974 · S/N 28-7505031 N3216QSoma 1953 LLC · Arcadia, FLBuilt 1977 · S/N 28R-7703097 N32170Kenslow Michael · Denton, TXBuilt 1974 · S/N 28-7505032 N32171Chicken Hawk Aviators LLC · Pembroke Pines, FLBuilt 1974 · S/N 28-7505033 N32172International Aviation Group LLC · Lake Wales, FLBuilt 1974 · S/N 28R-7535030 N32177Ace Aircraft Leasing Inc · Nazareth, PABuilt 1974 · S/N 28-7525031 N32178Nebraska Generator Service LLC · Gibbon, NEBuilt 1974 · S/N 28-7525032 N3217WNorth Anthony B · Bloomfield, CTBuilt 1965 · S/N 32-19 N32181Weaver James D · Montgomery, INBuilt 1974 · S/N 28-7515088 N32187Free Lutheran Association Of Pilot Supporters Inc · Plymouth, MNBuilt 1974 · S/N 32-7540021 N32189Long Todd A · Maple Plain, MNBuilt 1974 · S/N 28-7515090 N32191Czyszczon Aviation LLC · St Pete Beach, FLS/N 28-7515092 N32192White Charles J · Spring Lake, MIBuilt 1974 · S/N 28-7515093 N32194Parker Brandt · Hillsboro, WIBuilt 1974 · S/N 28-7505036 N32196Overstreet Bradley · Greenville, SCBuilt 1974 · S/N 28R-7535034 N32197Brunzlick Larry R · Chuckey, TNBuilt 1974 · S/N 32-7540022 N32198Garrison Resource Development LLC · Bridgeport, TXBuilt 1974 · S/N 28-7525035 N3219RSotelo Aviation LLC · Naples, FLBuilt 1969 · S/N 28R-31132 N321CNInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28R7803166 N321DNBrookway Aviation LLC · Brookhaven, MSBuilt 1971 · S/N 28-7125236 N321DPDelta Papa LLC · Henderson, NVBuilt 1979 · S/N 32-7940032 N321DRSavakinas Alan M · Clarence, NYBuilt 1979 · S/N 28-8090011 N321GBTwisted Roots Aviation LLC · Chesterton, INBuilt 1964 · S/N 28-10413 N321HPNfas LLC · League City, TXBuilt 1974 · S/N 32-7440099

Back to AD 87-08-08 R3