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.

N6907JFisher Bradley J · Bryant, INBuilt 1976 · S/N 32R-7680384 N6908BMeriden Aviation Center LLC · Meriden, CTBuilt 1985 · S/N 28-8516050 N6909ADupont Alexander Rene · East Taunton, MAS/N 28-8516053 N6909TAlpha-One Air Service LLC · Concord, NCS/N 28-8516049 N690HAAims Community College · Greeley, COBuilt 2025 · S/N 2881865 N690JTAviationmt LLC · Kalispell, MTS/N 28-7205042 N690LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881196 N690PMMiddlefield Farm And Garden Co · Middlefield, OHBuilt 2024 · S/N 2881728 N6910JPlane Nonsense Inc · Middletown, DEBuilt 1976 · S/N 28-7615395 N6910PBlue Skies Aviation LLC · Algona, IABuilt 1985 · S/N 28-8511008 N6911JJacksonville Airport Authority · Jacksonville, ILBuilt 1976 · S/N 28-7615396 N6911PMalo Blake Ridgway Trustee · Portland, ORBuilt 1985 · S/N 28-8590050 N6911QKirby Richard L Trustee · Albuquerque, NMBuilt 1985 · S/N 28-8511009 N6911WSwanson Naomi L · Dalton, GAS/N 28R-8531009 N6912JHammond Brian M · Gresham, ORBuilt 1976 · S/N 28-7690427 N6912WTop Flight Aviation Snh LLC · Savannah, TNBuilt 1965 · S/N 28-21287 N6913JFlight Time LLC · Conover, NCBuilt 1976 · S/N 28-7690428 N6913RAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 28-8590054 N6913SRural Development Corp 1 · Steamboat, COBuilt 1985 · S/N 28-8511010 N6913WAden James D · Gothenburg, NEBuilt 1965 · S/N 28-21288 N6914AFlyn 6914 Alpha LLC · Oak Island, NCBuilt 1985 · S/N 28-8511011 N6914JKreppel Frederick W · Wayne, PABuilt 1976 · S/N 28-7690429 N6914WPearson Timothy M · Waterville, OHBuilt 1965 · S/N 28-21084 N6915TSpier Samuel · Carson City, NVBuilt 1985 · S/N 28-8590058 N6915WOso Air LLC · Missoula, MTBuilt 1965 · S/N 28-21086 N69165Locaero Services Inc Trustee · Wilmington, DEBuilt 1985 · S/N 28-8516060 N6917DOlds Forge Flyers Inc · Lansing, MIBuilt 1985 · S/N 28-8590061 N6917GMarvell Aviation LLC · Marvell, ARBuilt 1985 · S/N 28-8590062 N6917WCloutier Michael C · Waddell, AZBuilt 1965 · S/N 28-21088 N6918WTopping Warren J · Sagaponack, NYBuilt 1965 · S/N 28-21089 N6919JFlying Is Fun LLC · Atlanta, GABuilt 1976 · S/N 28-7615397 N6919MWest Byron Chad · Blue Grass, IABuilt 1985 · S/N 28-8511013 N6919RSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N 28R-8531011 N6919WN6919w LLC · Key West, FLBuilt 1965 · S/N 28-21090 N691FLKelley Keith B · Forney, TXS/N 28-7125628 N691JInternational Air Services Inc Trustee · Carson City, NVS/N 28R8631003 N691LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881197 N691MAMitchell Martin · Alpine, CABuilt 2002 · S/N 3257291 N691RPRegistration Pending · Mount Holly, VTRegistration pending, canceledBuilt 1969 · S/N 28R-35019 N6920GValley Boys LLC · Lakeville, MNBuilt 1985 · S/N 28-8590065 N6922JSystematic Management And Flight Training LLC · Kankakee, ILBuilt 1976 · S/N 28-7690431 N6922WRobirds Ryan E · Wheelersburg, OHS/N 28-21095 N6924WAlpha 3 LLC · Troy, KSBuilt 1965 · S/N 28-21098 N6926WCola Air LLC · Irmo, SCBuilt 1965 · S/N 28-21101 N6927JClear2fly Aerospace LLC · Daytona Beach, FLBuilt 1976 · S/N 28-7625257 N6928JCarbiener Ross E · Kewanee, ILBuilt 1976 · S/N 28-7615400 N6928WHammons Daniel G · Vadnais Heights, MNBuilt 1965 · S/N 28-21289 N692DWBroyles Danny Keith · New Castle, INBuilt 2005 · S/N 3257384 N692LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881217 N6930JSkypark Aero Club Inc · Troy, OHBuilt 1976 · S/N 28-7690432

Back to AD 87-08-08 R3