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.

N560BYShogbonyo Michael A · Arlington, TXBuilt 1973 · S/N 28R-7335333 N560FLBancroft Robert W · Aurora, NYBuilt 1975 · S/N 28-7625026 N560PUPurdue Aviation LLC · West Lafayette, INBuilt 2000 · S/N 2842098 N56101Seniram Air Inc · Wilmington, DEBuilt 1973 · S/N 28R-7335354 N56105Anderson Wendell R · Brainerd, MNBuilt 1973 · S/N 28-7325573 N5610UAnderson Aviation LLC · Bulverde, TXBuilt 1969 · S/N 28-26540 N56114Anderson Douglas · Queen Creek, AZS/N 28R-7335357 N56115Schenck Christopher R · The Woodlands, TXBuilt 1973 · S/N 28R-7335358 N56119Button Eric T · Austin, TXBuilt 1973 · S/N 28-7305532 N56125Upstate Flying Club Inc · Marcy, NYBuilt 1973 · S/N 28-7305535 N56126Moore Holdings LLC · Janesville, WIBuilt 1973 · S/N 28-7305536 N56129Skurzynski James S · Santa Ana, CABuilt 1973 · S/N 28R-7335361 N56130Flying Aces Aero-Fleet Inc · Guyton, GABuilt 1973 · S/N 28R-7335362 N56131Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 32-7300052 N56134Buxton Richard L · Boise, IDBuilt 1973 · S/N 28-7325578 N56136Weed Brian Jeffrey · Omaha, NEBuilt 1973 · S/N 28-7305538 N5613UAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1970 · S/N 28-26543 N5613VKempton Larry G Jr · Grand Junction, COS/N 28-7716187 N5613WHocking Terry G · Nashwauk, MNBuilt 1962 · S/N 28-753 N56140Lets Fly Az LLC · Scottsdale, AZBuilt 1973 · S/N 28-7305539 N56141Simmerer Stephen J · Allenton, MIBuilt 1973 · S/N 28R-7335364 N56143Sisson Virginia B · Houston, TXBuilt 1973 · S/N 32-7340163 N56149Lets Fly LLC · Albemarle, NCBuilt 1973 · S/N 28-7325579 N5614WColeman John H · Jackson, MIBuilt 1962 · S/N 28-754 N56155Blackmon Ethan T · Hot Springs, ARS/N 32-7300053 N56158Munyon William · Vineland, NJBuilt 1973 · S/N 28-7325583 N5615WH&H Aviation LLC · Lehi, UTBuilt 1963 · S/N 28-755 N56160Thatcher Michael · Delaware, OHBuilt 1973 · S/N 28-7305543 N56161Ohmart Jeffrey A · Wichita, KSBuilt 1973 · S/N 28-7305544 N56177Bartsch Terry L · Nerstrand, MNBuilt 1973 · S/N 32-7340164 N5617UManagement Company Of South Carolina LLC · West Columbia, SCBuilt 1969 · S/N 28-26406 N5617WRose Dean R · Appleton, WIBuilt 1962 · S/N 28-758 N56182Gerst Peter C · Williamsport, PABuilt 1973 · S/N 28-7325586 N56190Bertch Gary M · Waterloo, IABuilt 1973 · S/N 28-7305550 N56191Twedt Jeffrey Lee · Montrose, SDS/N 28R-7335379 N56194Eds Aloft Inc · Mooresville, NCBuilt 1973 · S/N 32-7300055 N56198Holden James R Jr · Milton, GABuilt 1973 · S/N 28-7325588 N5619WIsbell David Myles · Tucson, AZBuilt 1962 · S/N 28-761 N561BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010040 N561FLOnwe Edward E · San Antonio, TXBuilt 1971 · S/N 28-7125402 N561MAMcdonald Jeffrey D · Chilmark, MABuilt 2003 · S/N 2843561 N561MHDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 28-7690264 N561PKKlopchic Peter G · Seattle, WABuilt 1973 · S/N 32-7340124 N561PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842103 N561SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881399 N561TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881861 N56201Kaney Howard W · West Bend, WIBuilt 1973 · S/N 28-7325590 N56202Kunze Paul C · Tempe, AZBuilt 1973 · S/N 28-7305551 N56204Andreas Charles V · Neenah, WIBuilt 1973 · S/N 28-7305552 N56211Bergstrom Aircraft Inc · Pasco, WABuilt 1973 · S/N 28R-7335384

Back to AD 87-08-08 R3