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.

N3569WFossum Richard F · Salado, TXBuilt 1966 · S/N 32-461 N3569XPrice Walter R · Beavercreek, OHBuilt 1979 · S/N 32R-8013030 N356ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010056 N356BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881805 N356CWinkler Noel A · Ann Arbor, MIBuilt 1965 · S/N 28-20995 N356DPMid America Aircraft LLC · O Fallon, ILBuilt 1978 · S/N 32R-7885158 N356MKNorth Star Aviation Inc · Mankato, MNBuilt 2021 · S/N 2881503 N356MTGlasscock David L · Lakewood, COBuilt 1965 · S/N 28-21274 N356NDAir Shares LLC · Casper, WYBuilt 2003 · S/N 2842184 N356VAVictory Aviation Club Inc · Hamilton, OHBuilt 1981 · S/N 32-8206008 N35705Paris Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-8016207 N35718Parmerlee David · Grand Rapids, MIBuilt 1979 · S/N 32R-8013032 N3571CEgan Michael S · El Paso, TXS/N 28-8016209 N3571LPeltier Scott M · Longwood, FLS/N 28-8011071 N3571PRegistration Pending · Myrtle Beach, SCRegistration pendingBuilt 1979 · S/N 28-8011069 N3571WJtw Financail Services · Norfolk, NEBuilt 1966 · S/N 32-463 N3572BPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 32R-8013033 N3572DTrade Winds Aviation Holdings LLC · Lewes, DES/N 32R-8029033 N3572MPlane Nonsense Inc · Middletown, DEBuilt 1978 · S/N 28-7816356 N3572XKelsoe Gregory Lyle · Clermont, FLBuilt 1979 · S/N 28-8016213 N35732Minney Andrew · Memphis, TNBuilt 1979 · S/N 28-8016195 N35734Registration Pending · Blairsville, GARegistration pendingBuilt 1979 · S/N 28-8016199 N3573WRay Blake · Midland, TXBuilt 1966 · S/N 32-466 N3574CAtd Pilot Training LLC · Kansas City, MOBuilt 1979 · S/N 28-8016200 N3574JI.F.C. Inc · Wayne, NEBuilt 1979 · S/N 28-8090196 N3574KDes Moines Flying Club LLC · Indianola, IAS/N 28-8090197 N3574QOlson LLC · Newberg, ORS/N 28R-8031040 N3574RGarner Financial Management Inc · Franklin, TNBuilt 1979 · S/N 32-7940287 N3574XSummit Place Aviation LLC · Dayton, TNS/N 28-8011060 N35755Varin Joseph J · Smithfield, RIBuilt 1979 · S/N 28-8090200 N3575AScoval Aviation LLC · Murray, KYBuilt 1979 · S/N 32R-8013034 N3575KN83993 LLC · Cherry Hill, NJS/N 32R-8013037 N3575UJ P Aviation LLC · Kingfisher, OKBuilt 1979 · S/N 28-8090198 N3575XSmith Foster Fritz · Bishopville, SCBuilt 1979 · S/N 28-8090199 N3576HJohnson Grant J · Doylestown, PABuilt 1979 · S/N 28-8090205 N3576JStephens Lloyd G · Saratoga, CABuilt 1979 · S/N 28-8090206 N3576MFly Legacy Planes LLC · Philadelphia, PABuilt 1978 · S/N 28-7890315 N3576RDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1979 · S/N 28-8090207 N3576WEllison David L · Stockbridge, GABuilt 1966 · S/N 32-469 N3576XField Aviation LLC · Fairview, TXBuilt 1979 · S/N 32R-8029035 N3577DAga Aviation LLC · Lewes, DEBuilt 1979 · S/N 32R-8029036 N35789Barrett Robin C · Holwaloa, HIBuilt 1979 · S/N 28-8016230 N3578KWienhold Kevin · Cuyahoga Falls, OHBuilt 1967 · S/N 28-23636 N3579QSchwartz Douglas · Plymouth, MIBuilt 1979 · S/N 32R-8029039 N3579WGuzman Anthony J · Hacienda Heights, CABuilt 1966 · S/N 32-472 N357BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2025 · S/N 2881912 N357JAEagle Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020077 N357KKDkk LLC · Indian Rocks Beach, FLS/N 28-7715074 N357MKNorth Star Aviation · Mankato, MNBuilt 2022 · S/N 2881523 N357MPEnsminger Edward C · Maryville, MOBuilt 1974 · S/N 28-7505103

Back to AD 87-08-08 R3