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.

N5922UPagan Jose A · Kokomo, INBuilt 1970 · S/N 28-26408 N5922VHopper David · Mcgregor, TXBuilt 1977 · S/N 32R-7780378 N5923WPremier Pilots LLC · Herriman, UTBuilt 1966 · S/N 28-3246 N5924FN5924f LLC · Cocoa, FLS/N 28-7715159 N5924UOrganization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1970 · S/N 28-26815 N5924VRegistered aircraftBuilt 1977 · S/N 32R-7780380 N5924WPribbenow Dennis A · Payson, AZBuilt 1966 · S/N 28-3273 N5926FRegistered aircraftBuilt 1976 · S/N 28-7790143 N5926UIron Flyer Of Cuzamil LLC · Lewes, DES/N 28-26739 N5926WLeonard Jeffrey A · Bakersfield, CABuilt 1966 · S/N 28-3311 N5927WKochling Christopher · Houston, TXBuilt 1966 · S/N 28-3331 N5928WRegistered aircraftN-number assigned, not yet registeredS/N 28-3367 N5929WEdwards Allan · Leesburg, VABuilt 1966 · S/N 28-3368 N592CJAims Community College · Greeley, COBuilt 2019 · S/N 2881183 N592FLGrey Rose Air LLC · Edenton, NCBuilt 1971 · S/N 28-7125455 N592KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843931 N592PTRegistered aircraftBuilt 1976 · S/N 32R-7680347 N5930USplendid Air Leasing LLC · Dover, DEBuilt 1970 · S/N 28-26726 N5930WGraham James C Co-Trustee · Bellville, OHBuilt 1966 · S/N 28-3376 N5931UJ And H Aircraft Leasing Inc · Palmyra, PABuilt 1970 · S/N 28-26814 N5932FWingin' It Aviation LLC · Glendale, CABuilt 1976 · S/N 28-7790144 N5932URegistration Pending · Bulverde, TXRegistration pendingBuilt 1971 · S/N 28-7125143 N5932VMacair Aviation LLC · Xenia, OHS/N 28R-7737076 N5932WSchaaf Rodney B · Bowman, NDBuilt 1966 · S/N 28-3383 N5934VLuvsflying Flight Training LLC · Staten Island, NYBuilt 1978 · S/N 28-7816603 N5934WDear Stephen R · Pioneer, CABuilt 1966 · S/N 28-3408 N5935FBartow Municipal Airport Development Authortiy · Bartow, FLS/N 28-7790145 N5935VRzr Aviation LLC · South Jordan, UTS/N 28R-7703169 N5937VLeftridge Dustin · Kalispell, MTBuilt 1977 · S/N 28-7710044 N5937WMikesell Lloyd L · Kokomo, INBuilt 1966 · S/N 28-3437 N5938ULame Duck Aviation LLC · Leesburg, INBuilt 1970 · S/N 28-26829 N5938WDewald Joseph L · Fort Wayne, INBuilt 1966 · S/N 28-3452 N5939WPhillips Morris · Decatur, GABuilt 1966 · S/N 28-3498 N593FLEmpire Aviators LLC · Long Island City, NYBuilt 1971 · S/N 28-7125456 N593SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881408 N593SPFull Rudder Flyers LLC · Mesa, AZBuilt 1966 · S/N 28-22459 N5940UStrong Colin · Portland, ORFirst renewal noticeBuilt 1970 · S/N 28-26830 N5941WCunningham James R · Collierville, TNBuilt 1966 · S/N 28-3518 N5942FBartak Paul R Jr · Saint Peters, MOBuilt 1976 · S/N 32R-7780022 N5943URoth Larry · Marion, IABuilt 1970 · S/N 28-26849 N5943WSallee Steven A · St George, UTS/N 28-3482 N5944WFerguson Robert C · Cornelia, GAS/N 28-3529 N5945KElston Rory · Angels Camp, CABuilt 1979 · S/N 28-7911203 N5945WHensley Roger A · Rosamond, CAS/N 28-3577 N5946UBlack Howard J Jr · Bethpage, TNBuilt 1970 · S/N 28-26846 N5947WPierce Colby · Midland, TXS/N 28-3618 N5949U5949 Inc · Boulder City, NVBuilt 1970 · S/N 28-26768 N5949WSutton Warren L · Loris, SCBuilt 1966 · S/N 28-3641 N594SPFrench David J · Aptos, CABuilt 1967 · S/N 28-22644 N5950KCoco Aircraft Inc · Merritt Island, FLBuilt 1978 · S/N 28-7816585

Back to AD 87-08-08 R3