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.

N8471TGorman Aviation LLC · Bartlesville, OKBuilt 1981 · S/N 28-8290071 N8471WDeboer William J · Andover, NJBuilt 1965 · S/N 28-2712 N8472WInfinite Air Center LLC · Albany, ORS/N 28-2714 N8473BWrightsville Aviation Partners LLC · Wilmington, NCS/N 28-8290070 N8473CR K Air Ltd · Harrisburg, PABuilt 1981 · S/N 32R-8213014 N8473RJones Kerry A · Sand Springs, OKBuilt 1966 · S/N 28-22379 N8473WSimsbury Aviation Services LLC · Simsbury, CTS/N 28-2715 N8475WHicks Blake · Metter, GABuilt 1965 · S/N 28-2717 N8476RKyzer Kevin · Fort Mill, SCBuilt 1966 · S/N 28-22383 N8478RBauman Benjamin S · Harrison, TNS/N 28-22385 N8479FDubois County Airport Authority · Huntingburg, INBuilt 1976 · S/N 28-7715270 N8479WMckinnon Mel · Dickson, TNBuilt 1965 · S/N 28-2723 N847AAAb Prop Plan I LLC · Metairie, LABuilt 2025 · S/N 2881847 N847AMCti Aircraft Leasing LLC · Memphis, TNS/N 2881303 N847EJackson Bradley D · Branson, MOBuilt 1965 · S/N 28-2732 N847TCTexas State Technical College · Waco, TXBuilt 2023 · S/N 28020147 N8480CShipalowski James M · Naples, FLBuilt 1976 · S/N 28-7615127 N8480FSt Pete Aviation Services LLC · St Petersburg, FLBuilt 1976 · S/N 28-7715271 N8480RRegistered aircraftBuilt 1966 · S/N 28-22388 N8481FRegistration Pending · Marshalltown, IARegistration pending, pending cancellationBuilt 1976 · S/N 28-7715272 N8481WHamilton John R · Farmington, ARBuilt 1965 · S/N 28-2725 N8482RHarger Michael G · Custar, OHBuilt 1966 · S/N 28-22390 N8483FPlanchon Ben P · Menifee, CABuilt 1976 · S/N 28-7790250 N8483RWright Maurice R · Las Vegas, NVBuilt 1966 · S/N 28-22391 N8483WBrayman Aviation LLC · Hollister, MOBuilt 1965 · S/N 28-2727 N8484CRegistered aircraftBuilt 1976 · S/N 28-7610084 N8484FAero Activites LLC · Edgewood, NMBuilt 1976 · S/N 28-7790251 N8484RLegacy Aviation Group LLC · Orrstown, PABuilt 1966 · S/N 28-22394 N8484WBoyett Alton M Jr · Waco, TXBuilt 1965 · S/N 28-2733 N8485FGoff Mark A · Hot Springs, ARBuilt 1976 · S/N 32-7700008 N8486CDown To Fly! LLC · Ocean Springs, MSBuilt 1976 · S/N 28-7625120 N8486RBass Derrick Lamar · Semmes, ALBuilt 1966 · S/N 28-22396 N8486WBurke Richard A · Rock Port, MOBuilt 1965 · S/N 28-2730 N8487WWilson Darrell III · Mcpherson, KSBuilt 1965 · S/N 28-2731 N8488RSugrue James E · Tampa, FLBuilt 1966 · S/N 28-22399 N8488WForbis Aviation LLC · Durant, OKBuilt 1965 · S/N 28-2926 N8489RPatriot Aircraft Leasing LLC · Erie, COBuilt 1966 · S/N 28-22495 N8489WJayroe Clinton Walter · Germantown, TNBuilt 1965 · S/N 28-2734 N848AAAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881848 N848MAIcarus Flying Academy LLC · Farmingdale, NYBuilt 2026 · S/N 28020270 N848TLoggerhead Reef Aviation LLC · Jupiter, FLBuilt 1989 · S/N 3213027 N848TCTexas State Technical College · Waco, TXBuilt 2023 · S/N 28020148 N8490RSimecek Glen D · Kirkland, WABuilt 1966 · S/N 28-22401 N8491CTarleton Aaron Rayce · Salem, ALBuilt 1976 · S/N 28-7615113 N8491FRutherford Robert E · Maryville, TNBuilt 1976 · S/N 28-7725117 N8491RDarnell Benjamin F Jr · Sevierville, TNBuilt 1966 · S/N 28-22403 N8491WMunson Justin M · Augusta, GABuilt 1965 · S/N 28-2736 N8492FVintage Wings Aircraft LLC · Centerpoint, INBuilt 1976 · S/N 28-7715274 N8492WMoore Myron Keith · Amarillo, TXBuilt 1965 · S/N 28-2738 N8493CPlante Matthew · Blackstone, MABuilt 1976 · S/N 32R-7680118

Back to AD 87-08-08 R3