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.

N454KACharlie Alpha Bravo LLC · Spring Hill, KSS/N 28-7790454 N454MDRegistration Pending · Bulverde, TXRegistration pendingBuilt 1966 · S/N 28-3125 N454TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020242 N454XThree Wing Flight School LLC · Stratford, CTBuilt 1978 · S/N 28-7890318 N4550DCharlymark 7 Flight Club LLC · Jamaica, NYBuilt 1983 · S/N 28-8390041 N4550XAltitude LLC · Madison, WIBuilt 1975 · S/N 28-7625053 N4551FViser Timothy A · Cleveland, TNBuilt 1976 · S/N 28-7790044 N4551XLewis Michael A · Alexandria, VABuilt 1975 · S/N 28R-7635075 N4552JAg Air Squadron One LLC · Saint Joseph, ILBuilt 1968 · S/N 28R-30413 N4552QGrand Air LLC · Granby, COS/N 28R-7703127 N4552XWozniak Robert F · Baltimore, MDBuilt 1975 · S/N 32R-7680027 N4554TGlazer Aviation LLC · Owings Mills, MDBuilt 1972 · S/N 28-7205184 N4554XSchwartz Michael · Bethel, CTBuilt 1975 · S/N 28-7690035 N4555FRegistered aircraftBuilt 1976 · S/N 28R-7635416 N4555REagle Aeronautical Company LLC · Dover, DEBuilt 1965 · S/N 28-21294 N4555TJb Aviation LLC · Mason City, IAS/N 28R-7235087 N4556FReindeer Aviation LLC · Bloomfield Hills, MIBuilt 1976 · S/N 32-7600022 N4556QChief Aviation Services LLC · Ferriday, LAS/N 32R-7780333 N4557RThomson James A · Boron, CABuilt 1965 · S/N 28-21298 N4557TWomack Associates LLC · Lancaster, KYBuilt 1972 · S/N 28-7225188 N4557XPrime Property Investments LLC · Pevely, MOBuilt 1975 · S/N 32R-7680028 N4558JDaprile Jonathan · Port Charlotte, FLBuilt 1968 · S/N 28R-30418 N4558RMorgan Chad A · Sarepta, LABuilt 1965 · S/N 28-21300 N4559JBolduc Michael A · Strong, MEBuilt 1968 · S/N 28R-30419 N4559RCavu Flight LLC · Simpsonville, SCS/N 28-21301 N4559TLeek Aviation LLC · Wilmington, DEBuilt 1972 · S/N 28-7205185 N4559XJlp Flying LLC · Clewiston, FLBuilt 1975 · S/N 28R-7635089 N455BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010039 N455FLFisher Jeffrey D · Omaha, NEBuilt 1971 · S/N 28-7125250 N455HFlying 20 Club Inc · Newtown, CTBuilt 2000 · S/N 28-43393 N455MAA & J Aviation LLC · Madison, MSBuilt 2001 · S/N 32-57205 N4561QDew Thomas E · Oro Valley, AZBuilt 1977 · S/N 32R-7780334 N4561XAir Bhnb LLC · Statesboro, GAS/N 28-7625055 N4562RMcclure Richard A · Victoria, TXS/N 28-21304 N4562TSellers Kelly A · Crossville, TNS/N 28-7205186 N4562XVenture West LLC · Mesa, AZBuilt 1975 · S/N 28R-7635078 N4563FOcean City Flying Club Inc · Newport, RIBuilt 1976 · S/N 32R-7680460 N4563JPilling Ian M · Bonita, CABuilt 1968 · S/N 28R-30425 N4563XTriple D LLC · Scotland, PABuilt 1975 · S/N 32R-7680029 N4564FStern Aviation Inc · N Fort Myers, FLBuilt 1976 · S/N 28R-7635454 N4565FHughey Charles A Jr · Oak Ridge, TNBuilt 1976 · S/N 28-7725022 N4565RHenderson Javier · Raleigh, NCS/N 28-21308 N4565TSchendel Daryl R · Barstow, CABuilt 1972 · S/N 28R-7235094 N4566FMarcum Timothy T · Waddy, KYBuilt 1976 · S/N 28-7725023 N4566JDifilippo Antonio O · Spring Church, PABuilt 1968 · S/N 28R-30429 N4566RMedia Stew LLC · Carson City, NVBuilt 1965 · S/N 28-21309 N4566XZihala William · North Little Rock, ARBuilt 1975 · S/N 28R-7635079 N4568RChuss Edward J · Metamora, MIBuilt 1965 · S/N 28-21326 N4569RNoco Flying Club LLC · Fort Collins, COBuilt 1966 · S/N 28-21310 N4569XSequoias David O · Waxhaw, NCBuilt 1975 · S/N 287625057

Back to AD 87-08-08 R3