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.

N8224WDavis William M · Chattanooga, TNBuilt 1965 · S/N 28-2357 N82255Quinn John J III · Merritt Island, FLBuilt 1982 · S/N 32R-8213053 N8225PTenntech Corp · Wilmington, DEBuilt 1980 · S/N 32-8006066 N8225RNorris Craig A · San Carlos, CABuilt 1980 · S/N 32R-8029100 N8225UNagy John F · Whittier, CABuilt 1982 · S/N 28-8290143 N8225VRunge Thomas A · Sterling, VABuilt 1982 · S/N 28-8290144 N8225WLewis Devin H · Lacey, NJBuilt 1965 · S/N 28-2359 N8225XWarren Dennis J · Denver City, TXBuilt 1982 · S/N 28-8290145 N82268268 Holdings LLC · North Salt Lake, UTBuilt 1982 · S/N 28R-8231057 N8226HForward Jeffrey C · Oakes, NDS/N 28-8090114 N8226VParchman Travis R · Philadelphia, PABuilt 1980 · S/N 28-8016344 N82279Boyce Peter C · New Albany, INBuilt 1980 · S/N 32-8024027 N8227NRegistration Pending · Dawsonville, GARegistration pendingS/N 28-25432 N8227VGrabowski Matt · Selma, CABuilt 1980 · S/N 28R-8018085 N8227WQuarter Circle E Enterprises Inc · Yorba Linda, CABuilt 1965 · S/N 28-2365 N8227YSeminole Air Holdings Inc · Tampa, FLS/N 28R-8031114 N8228ASlater Charles · Delafield, WIBuilt 1980 · S/N 32R-8029101 N8228WKoaks Aviation LLC · Farmers Branch, TXBuilt 1965 · S/N 28-2276 N82291Bdas LLC · Canby, MNS/N 28R-8031116 N82294Snow Robert L · Newman Lake, WABuilt 1980 · S/N 28R-8031117 N8229EJones Bert F · Philipsburg, MTBuilt 1982 · S/N 32R-8229057 N8229FSterling Aviation · Concord, CAS/N 28-8090328 N8229PMacair Aviation LLC · Xenia, OHBuilt 1980 · S/N 28-8090330 N8229WRab Aviation Photography LLC · Lanexa, VABuilt 1965 · S/N 28-2304 N8229YLee Daniel B · Ajo, AZBuilt 1980 · S/N 28R-8018086 N8229ZCentral Ohio Aircraft Leasing LLC · Columbus, OHBuilt 1980 · S/N 28R-8031115 N822AGQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N 28R-7918142 N822GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881223 N822JPTakacs Mark · Ada, MIBuilt 1984 · S/N 32R-8429022 N822JSN822js LLC · Norcross, GABuilt 1973 · S/N 28R-7335425 N822NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 28010007 N822PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881249 N822TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881704 N822WSWallace State Community College · Hanceville, ALBuilt 2022 · S/N 28020098 N82300Quintero Joshua · Imperial, CAS/N 32-8024028 N82301Hudik Gary P · Chicago, ILBuilt 1982 · S/N 28R-8231061 N82303Rosales James Ian III · Bryan, TXBuilt 1980 · S/N 32R-8029103 N82318Aero Nautical Adventure LLC · Camano Island, WABuilt 1982 · S/N 28-8216167 N82319American Medical Emergency Serv Inc · Englewood, FLBuilt 1980 · S/N 28-8011122 N8231AKatsaliros Pete · Jackson, TNS/N 28-8216226 N8231QAvier LLC · Beverly, MABuilt 1980 · S/N 28-8016347 N8231SBrown Mark · Peoria, ILBuilt 1980 · S/N 28-8016348 N8231YTravis Michael · Burns, ORBuilt 1980 · S/N 28R-8018087 N8232AAero2nautical LLC · Marion, OHBuilt 1980 · S/N 32-8024029 N8232CLewis M Wayne · Chandler, AZBuilt 1975 · S/N 28-7615082 N8232NWithee Steven A · Batavia, NYBuilt 1969 · S/N 28-25437 N8232WR&E Stars LLC · Fairfax Station, VABuilt 1965 · S/N 28-2371 N82332Euroair Consultants LLC · Vero Beach, FLBuilt 1982 · S/N 28-8216175 N8233CAirquest Aviation Inc · Kentwood, MIBuilt 1975 · S/N 28-7615083 N8233TEast Bay Aviators N8233t · Kalispell, MTBuilt 1974 · S/N 28-7515128

Back to AD 87-08-08 R3