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.

N83160Mikeman Carl · El Cajon, CABuilt 1980 · S/N 28-8111042 N83164Mavity Michael D · Phoenix, AZBuilt 1980 · S/N 28R-8131051 N8316CUplands Aviation Management LLC · Mineral Point, WIBuilt 1975 · S/N 28-7625101 N8316EJustfly Inc · Houston, TXBuilt 1980 · S/N 28-8116116 N8316RDelagrange Nathan A · Hicksville, OHBuilt 1966 · S/N 28-22187 N8316STeague Philip · Rattan, OKBuilt 1980 · S/N 28-8190128 N83177Nobles Joshua L · Tacoma, WABuilt 1980 · S/N 28-8116118 N8317EAppshle Air LLC · Long Beach, CABuilt 1980 · S/N 32R-8113027 N8317FLuxairways LLC · Old Bethpage, NYBuilt 1980 · S/N 32R-8113028 N8317YG M P Aero Marine LLC · Lauderhill, FLBuilt 1980 · S/N 32-8124005 N83180John Cox LLC · De Witt, NEBuilt 1980 · S/N 28-8190135 N83182Devall Kelly · Phoenix, AZBuilt 1982 · S/N 32R-8329011 N83187Angler Aviation LLC · North Miami, FLBuilt 1980 · S/N 32-8106028 N8318CAviator Jet LLC · Dover, DES/N 28-7615087 N8318HParra Henry A Torres · Weston, FLS/N 28-8116121 N8318QPenn Flight Academy LLC · Quakertown, PABuilt 1980 · S/N 28-8190130 N8318RAir Wave Holdings LLC · Porter, TXBuilt 1966 · S/N 28-22189 N8318YMaverick Air LLC · Wildwood, MOBuilt 1980 · S/N 28-8190134 N83196Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 28R-8118045 N83197Jast Air LLC · Wilmington, DEBuilt 1980 · S/N 28-8111044 N8319NCapital Aviation LLC · Hickman, NEBuilt 1980 · S/N 32R-8113029 N8319SBradbury Graham Trustee · Winnebago, ILBuilt 1982 · S/N 28-8311007 N8319WBlaker Martin O · Rough And Ready, CABuilt 1965 · S/N 28-2494 N831BBVentec LLC · Fort Lauderdale, FLFirst renewal noticeBuilt 1999 · S/N 3246135 N831BFHuddleston Edward L · Oaktown, INBuilt 1966 · S/N 28-3502 N831EKPiper Aircraft Inc · Vero Beach, FLS/N 28020288 N831NDCirrus Aviation Inc · Sarasota, FLBuilt 1978 · S/N 28-7816351 N831PMAvier LLC · Beverly, MABuilt 2024 · S/N 2881735 N831THSkyline Air LLC · Perris, CAS/N 3257283 N831TSWingsleasing LLC · Wichita, KSBuilt 1974 · S/N 28-7415485 N83208Rothrock Cara J · Streator, ILS/N 28-8116124 N8320CRiffle Bruce H · Chesterton, INBuilt 1975 · S/N 28-7690115 N8320EFerber Michael M · Parker, COBuilt 1980 · S/N 28R-8131056 N8320HBlue Oasis Flight Support · Tamarac, FLBuilt 1980 · S/N 28R-8131057 N8320WOracle Aviation LLC · Omaha, NEBuilt 1965 · S/N 28-2495 N83210Chapman Jeremy · Niagara Falls, NYBuilt 1980 · S/N 32-8106035 N83212Salty Flights LLC · Labelle, FLBuilt 1980 · S/N 32R-8113034 N83213P-R Aircraft LLC · Snellville, GABuilt 1981 · S/N 32R-8113035 N8321CJackson Blane · Beaufort, NCBuilt 1975 · S/N 28R-7635147 N8321HJust Plane Fellas LLC · Omro, WIBuilt 1980 · S/N 28-8116125 N8321LArevalo Gilbert Jr · Loranger, LABuilt 1980 · S/N 28-8190136 N8321MFox Two LLC · Camino, CABuilt 1980 · S/N 28-8190137 N8321RThompson Grady R · Athens, ALBuilt 1966 · S/N 2822192 N8321TRobinson Denise · Middletown, CTBuilt 1980 · S/N 28-8190140 N8321WWeighman David R · Battle Creek, MIBuilt 1965 · S/N 28-2496 N8321XPiper Investments · Visalia, CABuilt 1980 · S/N 28R-8131060 N83225Wiser Air LLC · Eastchester, NYBuilt 1982 · S/N 28R-8331007 N8322KSmith Gregory L · West Des Moines, IABuilt 1980 · S/N 32R-8129031 N8322LHorizon Aviation Of Myrtle Beach LLC · Myrtle Beach, SCBuilt 1980 · S/N 32R-8129032 N8322PBroken Arrow Crop Insurance Inc · Perryton, TXFirst renewal noticeBuilt 1980 · S/N 32R-8129033

Back to AD 87-08-08 R3