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.

N36424Fmy Inc · Honolulu, HIBuilt 1978 · S/N 28-7890514 N3642WMasia Matt D · Paso Robles, CABuilt 1966 · S/N 32-545 N36440Aircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 32-7840162 N36445N36445 LLC · Miami Lakes, FLS/N 32R-7885188 N3644KDraheim Allan C · Lagrange, GABuilt 1967 · S/N 28-23663 N3644RRegistration Pending · Sarasota, FLRegistration pendingBuilt 1969 · S/N 28-5742 N36456Charles Ho Consultants LLC · Beverly, MABuilt 1978 · S/N 28-7890516 N3645WDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 32-549 N36463S&D Adventures LLC · Saint George, UTBuilt 1978 · S/N 32R-7887044 N3646WWap Air LLC · Newburgh, INBuilt 1966 · S/N 32-550 N36470Proctor Charles H · Conroe, TXBuilt 1978 · S/N 28-7890518 N3647KRayman Bethany A · Salem, SDS/N 28-23666 N3647RRegistration Pending · Indianapolis, INRegistration pendingBuilt 1970 · S/N 28-5744 N3647WNichols Robert H Jr · Normandy, TNBuilt 1966 · S/N 32-551 N3648KBonanno John W · Oceanside, NYBuilt 1967 · S/N 28-23667 N3649151st Aero Squadron LLC · Hoover, ALBuilt 1978 · S/N 28-7890519 N36496Moseler Scott · Barrington, ILBuilt 1978 · S/N 28R-7803326 N3649RCummings Jason M · San Rafael, CABuilt 1969 · S/N 28-5746 N3649WTurbo Six LLC · Wilmington, DEBuilt 1966 · S/N 32-554 N364AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881990 N364MCLesser Antilles Corp Trustee · Wilmington, DEBuilt 1973 · S/N 32-7300039 N364MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881654 N364ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881645 N3650RScd Medical LLC · Alexandria, LABuilt 1969 · S/N 28-5747 N36511Worley Regenna G · Ellijay, GABuilt 1978 · S/N 28-7890520 N36516Collum Aviation LLC · Milton, FLBuilt 1978 · S/N 32R-7887048 N3651WTraxler Christopher V · Russia, OHBuilt 1966 · S/N 32-556 N36523Waymire David John · Fishers, INBuilt 1978 · S/N 32R-7887049 N36525Orr Richard J Jr · Anthem, AZBuilt 1978 · S/N 32R-7887050 N3652RShales Rene J · Hampshire, ILBuilt 1969 · S/N 28-5756 N3652WValiair Limited Co Trustee · Casper, WYS/N 32-557 N3653RSingh Harsimran · Las Vegas, NVBuilt 1970 · S/N 28-5758 N36541Plains Aviation · Mitchell, SDBuilt 1978 · S/N 28-7890521 N36546Lighthouse Drones LLC · New Smyrna Beach, FLBuilt 1978 · S/N 32R-7885193 N3654KBeaber Michael J · Fremont, OHBuilt 1967 · S/N 28-23673 N3654RSierra Delta 1 LLC · Dover, DEBuilt 1969 · S/N 28-5759 N36555Smith Jeffrey D · Murrells Inlet, SCBuilt 1978 · S/N 32R-7885194 N36563Ware Richard A · Versailles, OHBuilt 1978 · S/N 28-7890513 N36567Kempton Larry G Jr · Grand Junction, COBuilt 1978 · S/N 28-7890522 N3656WNuvision Heaqlth Center · Macomb, MIBuilt 1966 · S/N 32-562 N36574California In Nice Inc · San Jose, CABuilt 1978 · S/N 28R-7837284 N36575Brill Charles F · Spring, TXBuilt 1978 · S/N 32R-7885195 N36582Dias Paul Brian · Bakersfield, CABuilt 1978 · S/N 32R-7887058 N36583Trident Aircraft Inc · Easton, MDBuilt 1978 · S/N 28-7816647 N36588Moseley Richard W · Lakewood Ranch, FLBuilt 1978 · S/N 32R-7885196 N3658WFlying 20 Club Inc · Springfield, ILBuilt 1966 · S/N 32-564 N36590American Aircraft Sales LLC · Lincolnshire, ILBuilt 1978 · S/N 32R-7885197 N36591Piper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 32R-7887056 N3659KDumont Mark · Brush Prairie, WABuilt 1967 · S/N 28-23676 N3659MTrent Daniel E · Las Vegas, NVBuilt 1978 · S/N 28-7890320

Back to AD 87-08-08 R3