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.

N5027WJohnson Dennis E · Factoryville, PABuilt 1961 · S/N 28-28 N5028SSmith David J · Elkhart, INBuilt 1970 · S/N 28R-35772 N5028TDrake Charles R · Claremore, OKBuilt 1972 · S/N 28R-7235178 N5029SChop Bert D · Oak Grove, LABuilt 1970 · S/N 28R-35775 N5029WJaycor Foundation · Buirr Ridge, ILBuilt 1961 · S/N 28-31 N502FLBeasley James L · Abilene, TXBuilt 1971 · S/N 28-7125321 N502MWickham Steven Jr · Billings, MTBuilt 1966 · S/N 28-3690 N502MRBozovich Nicholas G II · Pittsburgh, PABuilt 1978 · S/N 28-7911051 N502NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2021 · S/N 2881475 N5031SBrodowsky Thomas · West Bloomfield, MIBuilt 1970 · S/N 28R-35790 N5031WBowers Mark A · Afton, VABuilt 1961 · S/N 28-33 N5032TFree Lutheran Association Of Pilot Supporters Inc · Plymouth, MNBuilt 1972 · S/N 28-7225325 N5033SGpsp Aviation LLC · Bronx, NYBuilt 1970 · S/N 28R-35762 N5034MHood Bruce Allen Jr · Windsor, SCBuilt 1965 · S/N 28-20749 N5034SPlattsmouth Aviation LLC · Plattsmouth, NES/N 28R-35801 N5035SReady Airways LLC · Roseville, CABuilt 1970 · S/N 28R-35766 N5036SArrow II Flyers LLC · Jacksonville, FLBuilt 1970 · S/N 28R-35804 N5037SGannon Gary L · Cumberland, WIS/N 28R-35781 N5038SRegistration Pending · Fort Worth, TXRegistration pendingS/N 28R-35806 N5038TBennett Howard N · Georgetown, KYBuilt 1972 · S/N 28-7225326 N5038WMarx Karl E · Juneau, AKBuilt 1961 · S/N 28-40 N5039TMitchell Robert D · Freehold, NYBuilt 1972 · S/N 28-7225328 N503AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2020 · S/N 28020003 N503ETCarnahan Eric Q · Sardinia, OHBuilt 1965 · S/N 28-10598 N503VFC&H Aviation LLC · Greenwood Village, COBuilt 2003 · S/N 3255004 N5040POld Seale Properties LLC · Ft Mitchell, ALBuilt 2001 · S/N 2843447 N5040TGamblin Ryan · Perry, GABuilt 1972 · S/N 28-7205241 N5041SZelener Howard M · Redlands, CABuilt 1970 · S/N 28R-35788 N5042SBlair & Company Aero Partners LLC · Raleigh, NCBuilt 1971 · S/N 28R-7135117 N5042TWells Thomas R · Chicago, ILBuilt 1972 · S/N 28R-7235182 N5043WRushton Harold E · Nashville, TNBuilt 1961 · S/N 28-45 N5044MMojocreatives Inc · Avondale Estates, GABuilt 1965 · S/N 28-20756 N5045TTruex Theodore L · Peachtree City, GABuilt 1972 · S/N 28-7225332 N5046TStp Flight LLC · Saint Paul, MNBuilt 1972 · S/N 28-7225333 N5047WCooper James · Indianapolis, INBuilt 1961 · S/N 28-49 N504APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843751 N504AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2020 · S/N 28020004 N504FLMustafa Abdelrahman · Euless, TXBuilt 1971 · S/N 28-7125324 N504NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2021 · S/N 2881476 N5050WLadeira Victor E · Holy Cross, AKBuilt 1961 · S/N 28-61 N5051SCall Of The Loon LLC · Missoula, MTBuilt 1971 · S/N 28R-7135118 N5052SWonnacott Dereck · Auburn Hills, MIBuilt 1970 · S/N 28R-35805 N5052TMatos Jonathan A · Kent, WABuilt 1972 · S/N 28-7225334 N5053SAviation Capital Management LLC · San Jose, CABuilt 1970 · S/N 28R-35808 N5053TSchneckenburger Kurt Partrick · Bethesda, MDBuilt 1972 · S/N 28-7205243 N5053WJonason David · Ocean Park, WABuilt 1961 · S/N 28-62 N5053YLeal Equipment Leasing Inc · Cocoa, FLBuilt 2001 · S/N 3257242 N5054SWoodson Billy R · Elon, NCBuilt 1970 · S/N 28R-35814 N5055SBattaile Jesse K · Chevy Chase, MDS/N 28R-35789 N5055TArrow 5055t LLC · Saint Helena, CABuilt 1972 · S/N 28R-7235186

Back to AD 87-08-08 R3