OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-R1')
    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-10-06-R1')
  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.

N57682Cartillar James R IV · Wynne, ARBuilt 1973 · S/N 631-74N57683Legros Donald P · Jennings, LABuilt 1973 · S/N 632-74N5768FCollum Aviation LLC · Milton, FLBuilt 1968 · S/N 28-25072N5768PBrooks David Paul · Mantorville, MNBuilt 1959 · S/N 24-846N5768UParsons Clinton K DBA · Etna, MEBuilt 1969 · S/N 28-26591N5768VSkyzure LLC · Chelsea, MIBuilt 1966 · S/N MA-21N57690Stockton Robert E · North Pole, AKBuilt 1974 · S/N 3-74N57691Heitz Joel L · Cozad, NEBuilt 1973 · S/N 418-74N57698Falkner Jeffrey A · Glennallen, AKBuilt 1977 · S/N 18-7709126N5769UKim Sungtae · Fort Worth, TXBuilt 1969 · S/N 28-26593N576FLRocky Top Corp · Erin, TNBuilt 1971 · S/N 28-7125425N576KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843937N576PAClear Skies LLC · Whitehall, PABuilt 1975 · S/N 28-7525331N576RDEmerian Rick S Trustee · Fresno, CABuilt 2009 · S/N 40249N576SPSo Cal Leasing LLC · El Cajon, CABuilt 2000 · S/N 172S8501N5770QJohnson Darryl · Fowler, COBuilt 1965 · S/N 3087N5770VAkins Terral S · Grain Valley, MOBuilt 1966 · S/N MA-25N5770WGallo Danny P · Nashotah, WIBuilt 1964 · S/N 28-1578N5771DEllison Stephen · Anchorage, AKBuilt 1956 · S/N 18-5273N5771HHill Bruce T · Ramona, CABuilt 2014 · S/N 91894N5771PWhisky Zulu Inc · Klamath Falls, ORBuilt 1959 · S/N 24-849N5771QLuchterhand Charles · Salem, ORS/N 744N5771VLow & Slow Aviation LLC · Westminster, COBuilt 1966 · S/N MA-22N5771WCrumpton Bradley N · Caddo Mills, TXBuilt 1964 · S/N 28-1579N5772DLong Randy B · Coleman, TXBuilt 1956 · S/N 18-5274N5772PKasakoff Lloyd Abraham · Houston, TXBuilt 1959 · S/N 24-850N5772QTweten Gary L · Glasgow, MTS/N 3088N5772UBernstein Matthew D · North Charleston, SCBuilt 1970 · S/N 28-26596N5772VSouthwest Truck Parts Inc · Pratt, KSS/N MA-24N5772WBallard Gary H · Soddy Daisy, TNBuilt 1964 · S/N 28-1580N5773EOppegard Nicholas · Eagle River, AKS/N 17273N5773MHulslander Taylor · North Pole, AKBuilt 1975 · S/N 18-7509082N5773QGunnerson Spencer · Murfreesboro, TNBuilt 1965 · S/N 745N5773UNelson Francis A · Winchester, VABuilt 1970 · S/N 28-26597N5773YMccabe Aero LLC · Grand Haven, MIBuilt 1965 · S/N 27-2902N5775EGates Rebecca S · GeorgetownNon-citizen corporation, flight hours not reportedS/N 17275N5775PChelf James Michael · Cedar Park, TXBuilt 1959 · S/N 24-853N5775QSinger David · Vandalia, OHBuilt 1965 · S/N 746N5775UBravo Tango Aviation · Spearfish, SDBuilt 1970 · S/N 28-26599N5776UBrainard Gary Keith · Olney, ILBuilt 1969 · S/N 28-26600N57777Thorsgard Keith A · Mcville, NDBuilt 1978 · S/N 18-7809094N5777UFossa Matthew A · Pensacola, FLBuilt 1969 · S/N 28-26601N5777VDe La Garza Jimmy · Granbury, TXBuilt 1966 · S/N MA-29N5777WMaschek Anothony Q · Killeen, TXBuilt 1964 · S/N 28-1585N57787Shoultys Shawn P · Denali Park, AKBuilt 1977 · S/N 18-7709131N5778PHunton Hugh R II · Midlothian, TXBuilt 1959 · S/N 24-857N5778QPars Avn Corp · Wilmington, DEBuilt 1965 · S/N 3091N5778VGlenn Larry D · Reynoldsburg, OHBuilt 1966 · S/N MA-37N57792Arizona Game & Fish Dept · Phoenix, AZBuilt 1977 · S/N 18-7709132N5779DAltenburg Scott J · Anchorage, AKBuilt 1956 · S/N 18-5295
Back to AD 87-10-06 R1