OpenAirDocs.org
AD 87-08-08 R3

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
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.

N3620WSemler Jason M · Cambridge, MNBuilt 1966 · S/N 32-521N3621XBig Bend Community College · Moses Lake, WABuilt 2018 · S/N 2881010N3622RN3622r LLC · Bradford, RIBuilt 1970 · S/N 28-5718N3625KAcl Airplane Holding LLC · Covington, TNBuilt 1967 · S/N 28-23658N36262Exodus Aviators Inc · Cedar Park, TXBuilt 1978 · S/N 32R-7885175N36276Gronning Skyler · Westby, WIBuilt 1978 · S/N 28-7816624N36281Hedgehog Management LLC · Salem, OHBuilt 1978 · S/N 28-7890503N36282Beverly Flight Center LLC · Danvers, MABuilt 1978 · S/N 28R-7837271N36292Qualitair LLC Trustee · MichelstadtS/N 32R7885179N36295Bar Aviation LLC · Eatonton, GABuilt 1978 · S/N 32R-7885180N36297Project 70 Audio Service Inc · Adel, GABuilt 1978 · S/N 32R-7885182N3629RJohns Brian A · Efland, NCBuilt 1970 · S/N 28-5725N3629WFly Code Repeat LLC · Lewes, DEBuilt 1966 · S/N 32-531N362ABReynolds Bruce G · Wausau, WIBuilt 1980 · S/N 32R-8029068N362DMRegions Aloft LLC · Brooksville, FLBuilt 2004 · S/N 3257362N362JDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 2843158N362MKNorth Star Aviation Inc · Mankato, MNBuilt 2022 · S/N 2881589N362NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881656N36304Capital Aviation II LLC · Bethesda, MDBuilt 1978 · S/N 28-7890504N3630MAmercani Mahmoud · Fayetteville, GABuilt 1978 · S/N 28R-7803182N3630RLachance John A · Thompson, CTBuilt 1971 · S/N 28-7125375N3630WScarborough Robert T · Yuma, AZBuilt 1966 · S/N 32-532N3631MTrekjet LLC · Southington, CTBuilt 1978 · S/N 28R-7803183N3633RGrammar Adrian Gates · Geneva, NYBuilt 1970 · S/N 28-5728N3634RRatkovich Stephen · Prospect Heights, ILBuilt 1971 · S/N 28-7125140N3634WCarey Nicholas Isaac · Clarkston, WABuilt 1966 · S/N 32-536N36355Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1978 · S/N 28-7816630N36358Hans Aviation Inc · Davie, FLBuilt 1978 · S/N 28-7816631N3635WSwieter Avionics LLC · Waverly, IAS/N 32-537N36361Smith Robert Ervin III · Mountain Top, PABuilt 1978 · S/N 32-7840158N36364Gordon Security Solutions LLC · Chester Springs, PABuilt 1978 · S/N 32-7840159N3636KCronin John M · Bremerton, WABuilt 1967 · S/N 28-23662N3637RGelinger Gary · Cape Carteret, NCBuilt 1970 · S/N 28-5732N3637WStruck Dennis L · Spirit Lake, IABuilt 1966 · S/N 32-539N36384Lisa Rocco J · Elkhart, INBuilt 1978 · S/N 28R-7837277N3638RDukeman James C · Apex, NCBuilt 1970 · S/N 28-5735N3638WCherokee Six LLC · Williamson, GABuilt 1966 · S/N 32-540N36390Robertson Kevin E · Austin, TXBuilt 1978 · S/N 32R-7887039N36393Meriden Aviation Center LLC · Meriden, CTS/N 28-7816633N36395Brittle Aviation LLC · Chapel Hill, NCBuilt 1978 · S/N 28-7816634N3639WYoungpeter David L · Spencerville, OHBuilt 1966 · S/N 32-542N363ACAig Aeronautics LLC · Guaynabo, PRBuilt 2000 · S/N 3246161N363MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881653N363RCWilliams Eric S · Miami, FLS/N 32-40438N36400Vlietstra Steven J · Hatley, WIBuilt 1978 · S/N 28-7890511N36401Over Your Head LLC · Erie, PABuilt 1978 · S/N 32R-7887040N36409Wire Wonder Inc · New York, NYNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 28-7816636N3641MSweet Water Air LLC · Kissimmee, FLBuilt 1978 · S/N 32-7840068N3641RGeorge Walker Field Inc · Bedminster, NJBuilt 1969 · S/N 28-5737N3641WMitchell Jeffrey Scott · Donalsonville, GABuilt 1966 · S/N 32-544
Back to AD 87-08-08 R3