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.

N5950WRegistered aircraftBuilt 1966 · S/N 28-3644 N5951ULink David R · The Dalles, ORBuilt 1970 · S/N 28-26803 N5952USlocombe Walter B · Bossier City, LABuilt 1970 · S/N 28-26823 N5953WDavis Kyle G · Waseca, MNS/N 28-3616 N5954UReed Mark A · San Bernardino, CABuilt 1970 · S/N 28-26751 N5954WHemacinto Valley Flying Club · Hemet, CABuilt 1966 · S/N 28-3694 N5955UBailey Doane E · Sharpsville, PABuilt 1970 · S/N 28-26777 N5955VWestern Aircraft Solutions · Temecula, CABuilt 1977 · S/N 28-7790516 N5956ULindsey Gary E Jr · South Deerfield, MABuilt 1970 · S/N 28-26782 N5958WWise Aviation Solutions LLC · Rio Vista, TXS/N 28-3764 N5959UOhnstad Andrew J · Webster, MNBuilt 1970 · S/N 28-26860 N595HPPickering Neil · Diamondhead, MSBuilt 1995 · S/N 3246017 N595MASterling Flight Training LLC · Jacksonville, FLBuilt 1976 · S/N 28R-7635259 N5960FBonventre Michael J · Greentown, PABuilt 1976 · S/N 28-7725071 N5960WNewman Matthew T · Cedar Park, TXBuilt 1966 · S/N 28-3807 N5962USieber Eric P · Shelburne, VTBuilt 1970 · S/N 28-26864 N5962WMcmath Stephen S · Spokane Valley, WABuilt 1966 · S/N 28-3821 N5963WPalm-Air Aviators LLC · Springville, UTBuilt 1968 · S/N 28-24780 N5964FDillard Gregory S · Columbus, MSBuilt 1976 · S/N 28-7715162 N5964UChandler Joseph R · Midlothian, TXS/N 28-26818 N5965WHadfield Brant C · Kirkwood, MOFirst renewal noticeBuilt 1966 · S/N 28-3812 N5966FHalter George R 3rd · West Chester, PABuilt 1976 · S/N 28-7790146 N5967VHinton Marie Catherine · Apple Valley, CAS/N 28R-7703173 N5967WZillah Heights Cherry Growers LLC · Zillah, WABuilt 1966 · S/N 28-3831 N5968WDalken Dustin A · Fairhope, ALBuilt 1967 · S/N 28-3860 N5969VNiver Randall H · Potomac, ILBuilt 1977 · S/N 32R-7780384 N596HPAtl Pilot LLC · Senoia, GABuilt 1996 · S/N 3246052 N596PHOtt Juston E · Newton, ALBuilt 1968 · S/N 28-24782 N596SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881409 N596TCWinyah Aviation LLC · Wilmington, DEBuilt 1979 · S/N 32-7940165 N5970UThatcher Jay C · Helena, OHBuilt 1970 · S/N 28-26857 N5970WBlessing Randall L · Lebanon, PABuilt 1967 · S/N 28-4020 N5971URegistered aircraftBuilt 1970 · S/N 28-26851 N5971WGoede Mark D · Wildwood, MOS/N 28-4021 N5972FFulhage Eric D · Yates Center, KSBuilt 1976 · S/N 28-7790148 N5972UToporkova Kamila E · Whitewater, CABuilt 1970 · S/N 28-26858 N5973WValant Group Inc · Valrico, FLBuilt 1967 · S/N 28-3919 N5974UW8s Enterprises LLC · Stillwater, OKBuilt 1970 · S/N 28-26861 N5977UMorrow Robert H · Wyndmoor, PABuilt 1970 · S/N 28-26862 N5979UWings Of Grace Ministries Inc · Melbourne, FLS/N 28-26867 N597AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881756 N597CBBrandon Air LLC · Valley Stream, NYBuilt 1989 · S/N 3213029 N597JFDiamond Travel LLC · Olive Branch, MSBuilt 1977 · S/N 28-7890262 N597JGKnoxville Flyers Inc · Knoxville, TNBuilt 1997 · S/N 2843087 N597SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881410 N597WBaccas Christopher · Sun City Center, FLBuilt 1971 · S/N 28-7125465 N5980UT A Aviation LLC · Tucson, AZBuilt 1970 · S/N 28-26870 N5980WCooke Carole J Trustee · Aguila, AZBuilt 1967 · S/N 28-4260 N5981UEast Sun Corp · Greensboro, NCS/N 28-26759 N5981WLudwing Jonathan · Tompkinsville, KYBuilt 1967 · S/N 28-4322

Back to AD 87-08-08 R3