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.

N8114FFlying Country Club Inc · Coal Valley, ILBuilt 1979 · S/N 28-8090136 N8114RSmith Scott V · Presque Isle, MEBuilt 1979 · S/N 28-8011017 N8114WZimny Jaroslaw · KrasocinS/N 28-2218 N8115BBlue Horizons Flying Club Inc · Perrysburg, OHBuilt 1979 · S/N 28-8016116 N8115HRivera Philip T · Las Vegas, NVS/N 28-8016117 N8115LDouble Greene LLC · Spout Spring, VABuilt 1979 · S/N 28-8016119 N8115PJla Aero LLC · State College, PABuilt 1979 · S/N 28-8016120 N8115WBaity Robert G · Yadkinville, NCBuilt 1965 · S/N 28-2219 N8116BAronbay LLC · Bartlett, ILBuilt 1979 · S/N 28-8016124 N8116JChapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1979 · S/N 28-8016125 N8116QShulins Paul · Wickenburg, AZBuilt 1979 · S/N 28R-8018017 N8116RJimmy & Ryans Totally Awesome Airplane Ventures Lc · Crete, ILBuilt 1979 · S/N 28R-8018018 N8116WKilbourne Garrot · Porum, OKS/N 28-2222 N8117BTafta James C · Charlestown, RIBuilt 1979 · S/N 28R-8031017 N8117KN8117k Piper Dakota LLC · Palm Beach, FLBuilt 1979 · S/N 28-8011019 N8117RZisa Reno J · Mesa, AZS/N 28-8011023 N8117SWong Scott L · Lino Lakes, MNBuilt 1979 · S/N 28-8011024 N8117WYracheta Alfred T · Fresno, CAFirst renewal noticeS/N 28-8011025 N8117ZOaces Aero Holdings LLC · Santa Rosa Beach, FLBuilt 1979 · S/N 28-8011026 N81188International Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 28-8211026 N8118QDakota Aviation Corp · Sayville, NYBuilt 1979 · S/N 28-8011030 N8118SMorgan Michael E Trustee · Redding, CABuilt 1979 · S/N 28-8011031 N8118TSmith David · Montvale, NJBuilt 1979 · S/N 28-8011032 N8118WHenson Anthony · Jasper, ALBuilt 1965 · S/N 28-2224 N8118XSchultz Robert J · Rapid City, SDBuilt 1979 · S/N 32R-8029011 N8118ZWest Metro Aviation LLC · Buffalo, MNBuilt 1979 · S/N 32R-8029013 N8119BChabrier Pierre H · Wesley Chapel, FLBuilt 1982 · S/N 28-8290092 N8119CHenry Gary A · Narragansett, RIBuilt 1979 · S/N 28-8016126 N8119HPiper Warrior LLC · Middleton, MABuilt 1979 · S/N 28-8016127 N8119PStelling William F · Fairbury, NEBuilt 1979 · S/N 28-8016128 N8119QBay Lux Ventures LLC · Tampa, FLBuilt 1979 · S/N 28-8016129 N8119ZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1982 · S/N 28R-8231031 N811ASS&A Flying LLC · Minden, NEBuilt 1978 · S/N 28-7890306 N811BLWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 2881853 N811GSTri-Delta Design LLC · Cedar Park, TXBuilt 1978 · S/N 32R-7885122 N811JBGaskin Aviation LLC · Tallahassee, FLBuilt 1989 · S/N 2811026 N81202Registration Pending · Augusta, KSRegistration pendingBuilt 1979 · S/N 28-8016144 N8120BGreat Northern Aircraft Inc · Griffith, INBuilt 1979 · S/N 28-8016134 N8120FPray Aviation Inc · Augusta, KSBuilt 1979 · S/N 28-8016136 N8120JCope Christopher J · Plumas Lake, CABuilt 1979 · S/N 28-8016140 N8120MMckissick John R · Westminster, MDBuilt 1979 · S/N 28-8016141 N8120XMccool Kenneth Wade · Olive Branch, MSBuilt 1979 · S/N 28-8016142 N8121FKraack Stephen T · Lithia, FLBuilt 1979 · S/N 28-8016145 N8121JSchluckebier Daniel C · Aldie, VABuilt 1979 · S/N 28-8090141 N8121KRegistered aircraftBuilt 1979 · S/N 28-8090142 N81223Eat Aviation LLC · Metter, GABuilt 1979 · S/N 32-7940263 N8122BErwin Mark N · Snyder, TXBuilt 1979 · S/N 28-8090149 N8122HSchlesinger Richard J · West Cornwall, CTBuilt 1979 · S/N 28-8090151 N8122QN8122q LLC · Venice, FLBuilt 1979 · S/N 28-8090152 N8122WRoberts Barry R · Aurora, COBuilt 1965 · S/N 28-2229

Back to AD 87-08-08 R3