Skip to content

Registered aircraft · 22,416

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.

N8594CNagia Omar Mohamed · Richmond, CAS/N 28-7625125 N8594FPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020275 N8594NKosciusko Skipper N · West Cornwall, CTBuilt 1971 · S/N 28-7105144 N8594WAlpha Berachah Omega LLC · Sanibel, FLBuilt 1963 · S/N 28-10106 N8595DPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020276 N8596NLsg Flying Services LLC · Sarasota, FLBuilt 1971 · S/N 28R-7135129 N8596WMcm Legacy Enterprise LLC · Olmsted Twp, OHS/N 28-10108 N8599NScott Lauren M · Lighthouse Point, FLBuilt 1971 · S/N 28-7105146 N8599WHackett Dean · Lake City, FLBuilt 1963 · S/N 28-10112 N859PUTrustees Of Purdue University · West Lafayette, INS/N 2881332 N859SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881742 N859TRaven Aviation LLC · Lexington, KYBuilt 1972 · S/N 28-7225288 N85BKBkv Aero Squadron LLC · New Port Richey, FLBuilt 1974 · S/N 28-7425284 N85CTAerobsession LLC · Erie, COBuilt 1966 · S/N 32-789 N85DJRegistered aircraftBuilt 1981 · S/N 32R-8129107 N85NAHampden Aviation Services Inc · Northampton, MAS/N 287816296 N85RWJkg LLC · Murfreesboro, TNBuilt 1976 · S/N 28-7715147 N85SPBurkett Jacob E · Polk City, FLBuilt 1976 · S/N 28-7690216 N85WABeckwith James N · Goldsboro, NCBuilt 1966 · S/N 28-21583 N8600NCen-Tex Wings LLC · Cedar Park, TXBuilt 1971 · S/N 32-7100021 N8601NLpm Sky Masters LLC · Green Cove Springs, FLBuilt 1971 · S/N 32-7100020 N8601WEtten Douglas E · Dalton, MNBuilt 1963 · S/N 28-10114 N86028Caudle James Solomon · Greenville, SCS/N 28-23644 N8604WMoore Eric D · Elkhart, TXBuilt 1963 · S/N 28-10118 N8605NTremper John D · Newton, NJBuilt 1971 · S/N 28-7125429 N8606EJ&H Aviation LLC · Middletown, DEBuilt 1976 · S/N 28R-7635191 N8609NBird Properties LLC · Roosevelt, UTBuilt 1971 · S/N 28-7105148 N8609WCherokee 8609w LLC · Morgan, UTS/N 28-10125 N860ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881385 N860DMC & C Aircraft Holdings Inc · Wilmington, DEFirst renewal noticeBuilt 1973 · S/N 32-7340169 N860PUTrustees Of Purdue University · West Lafayette, INS/N 2881333 N860SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881743 N860TCNorth Star Aviation Inc · Mankato, MNBuilt 2016 · S/N 2842417 N860UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020195 N8610NSkipper Donald J · Huntersville, NCBuilt 1971 · S/N 28R-7135131 N8611WSheppard Travis · Terrebonne, ORBuilt 1963 · S/N 28-10127 N8614NFarmers Bank Of Northern Missouri Na · Unionville, MOBuilt 1970 · S/N 32-7140006 N8614WRegistration Pending · Grand Junction, CORegistration pendingBuilt 1963 · S/N 28-10056 N8615WJefferson Community & Technical College Foundation · Louisville, KYS/N 28-10060 N8616WKlopsch Steven J · Colbert, WABuilt 1966 · S/N 28-10793 N8617WHacker George A · Renton, WABuilt 1963 · S/N 28-10131 N8618WRegistered aircraftBuilt 1964 · S/N 2810132 N8619EHogan Daniel L · Chapel Hill, NCBuilt 1976 · S/N 28-7625143 N861PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843945 N861PUTrustees Of Purdue University · West Lafayette, INS/N 2881334 N8620WPurcell Holdings Lc · Tremonton, UTBuilt 1963 · S/N 28-10134 N8621EUpdraft Leasing LLC · Tea, SDBuilt 1976 · S/N 28-7615143 N8621NMcdonald Timothy Shane · Saint Jacob, ILBuilt 1970 · S/N 32-7140014 N8622NPapp Adam P · Raleigh, NCBuilt 1971 · S/N 32-7140015 N8622WMoody Robert F · Salinas, CABuilt 1963 · S/N 28-10137

Back to AD 87-08-08 R3