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.

N456CASlake James T · Portage, INBuilt 1966 · S/N 28-10733 N456CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881506 N456LLemma Joseph M · Parker, COBuilt 1962 · S/N 28-863 N456PMBerry Michael G · Hot Springs, ARBuilt 1966 · S/N 28-22354 N456RRAir America Flight Center LLC · Daytona Beach, FLBuilt 1976 · S/N 28R-7635457 N456WPrez Carl · San Antonio, TXBuilt 1980 · S/N 28R-8131061 N456YDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 2843353 N4570TWinslow Dean L · Stanford, CABuilt 1972 · S/N 28-7210013 N4571TVandeventer Matthew S · Dillingham, AKS/N 32-7200023 N4571XFly Boys Aviation LLC · Tecumseh, MIS/N 28-7690039 N4573JRoss James A · Barrington, RIS/N 28R-30438 N4573RKaufmann Carl S · Springfield, MABuilt 1965 · S/N 28-21314 N4574JWakefield Aircraft LLC · Cooperstown, NDBuilt 1968 · S/N 28R-30439 N4574RKing Vincent A · Grand Junction, COBuilt 1965 · S/N 28-21316 N4575FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 28-7715049 N4575XPar Mar Bluffs LLC · Parker, SDS/N 28-7690034 N4576FDakota Aviation LLC · Sioux Falls, SDBuilt 1976 · S/N 28-7715050 N4576XElon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28R-7635081 N4577XFairhaven LLC · Meridian, MSBuilt 1975 · S/N 32-7600004 N4578TMeditz Robert S · Chalfont, PABuilt 1972 · S/N 28R-7235097 N4579RSmelser Brady W · Glendive, MTBuilt 1965 · S/N 28-21321 N4579TNavajo Air LLC · Scottsdale, AZBuilt 1972 · S/N 28R-7235098 N457AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881757 N457ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010057 N457FLApplebee Kevin · White Heath, ILBuilt 1971 · S/N 28-7125252 N457TThompson Ernest W Jr · Yukon, OKBuilt 1976 · S/N 28-7690218 N4580FRegistered aircraftBuilt 1976 · S/N 28-7790045 N4580RMartin James E · Rostraver Township, PABuilt 1966 · S/N 28-21322 N4581JN634mm LLC · Pelham, ALBuilt 1968 · S/N 28R-30450 N4581XRegistered aircraftBuilt 1975 · S/N 28-7690042 N4582JTew-Mac Aviation · Tewksbury, MABuilt 1968 · S/N 28R-30451 N4582RMartin Robert T · Huntsville, OHBuilt 1965 · S/N 28-21324 N45832Arenal Patrick T · Granbury, TXBuilt 1977 · S/N 28-7890048 N4583RDmac Aircraft LLC · Savannah, GABuilt 1965 · S/N 28-21325 N4583TKeppers Richard W · Alexandria, VABuilt 1972 · S/N 28R-7235099 N4583XMarquart Timothy Irving · San Antonio, TXFirst renewal noticeBuilt 1975 · S/N 28-7610037 N4584FStorm Flying Service Inc · Webster City, IAFirst renewal noticeBuilt 1976 · S/N 28-7790047 N4584JBradley Cody C · Auburn, NEBuilt 1968 · S/N 28R-30454 N4584RSiegel William G · Wellington, FLBuilt 1965 · S/N 28-21328 N4584TLion Air LLC · South Heart, NDBuilt 1972 · S/N 32-7240087 N4585XFrost Aviation Services Inc · Las Cruces, NMBuilt 1975 · S/N 28-7690043 N4586RGuasch Walter L · Reno, NVBuilt 1965 · S/N 28-21330 N4586XMccardle Michael L · Houston, TXBuilt 1975 · S/N 28R-7635086 N4587TStory'S Aviation Services LLC · Webster, FLBuilt 1972 · S/N 28-7225194 N4588JSierra Hotel Fliers LLC · Lexington Park, MDBuilt 1968 · S/N 28R-30459 N4588TLeavitt James W · North Ferrisburgh, VTBuilt 1972 · S/N 28-7205189 N4588XMaus Steven M · New Braunfels, TXBuilt 1975 · S/N 28-7615036 N4589JArthurs Nathanael L · Indiana, PABuilt 1968 · S/N 28R-30462 N4589XSek LLC · Concordia, MOS/N 28-7690045 N458AArcher Aero LLC · Wilmington, DEBuilt 2014 · S/N 2843799

Back to AD 87-08-08 R3