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.

N573ELStellaire Alliance LLC · Fort Worth, TXBuilt 1999 · S/N 2038N573JAYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 28020264N573MBWigley Barry L · Langston, ALBuilt 2024 · S/N 26009N573MWWhelan Company LLC · Hoover, ALBuilt 2005 · S/N 90815N573SMason Scott C · Lebanon, ORBuilt 1976 · S/N 913N573TLAsson David A · Sisters, ORS/N 573N573TMFarley Douglas C · Edmond, OKBuilt 1996 · S/N 001N57401Adams Kenneth · Marana, AZBuilt 1973 · S/N 376-73N57405Shoaf Douglas G · Lake Oswego, ORS/N 371-73N57407Britt Elaine L · Locust Grove, GABuilt 1973 · S/N 259-73N57408Phillips Thomas G · Fairbanks, AKBuilt 1973 · S/N 494-73N5740QOasis Aero Inc · Willmar, MNBuilt 1965 · S/N 3072N5740UBraden Daniel · Port Charlotte, FLBuilt 1969 · S/N 28-26556N5740WAdams Clay · Anacortes, WABuilt 1963 · S/N 28-1415N5740YJts Aero LLC · New Hampton, NYS/N 27-2864N57411Gregory Larry C Trustee · Farmington, MOBuilt 1973 · S/N 372-73N57412North County Flight Training Inc · Carlsbad, CABuilt 1973 · S/N 495-73N57413Miller Sybille A · Ashburn, VABuilt 1984 · S/N 24-1450N5741DJ&H Sewing & Vacuum Inc · Soldotna, AKBuilt 1956 · S/N 22-4441N5741FBrower Alan L · Califon, NJBuilt 1968 · S/N 28-25043N5741WGonzalez Jose M · Arlington, TXBuilt 1963 · S/N 28-1435N57421Snider Roger A · Harlem, MTBuilt 1973 · S/N 498-73N57422Heefner Frederick C · Greencastle, PABuilt 1998 · S/N 23077N57423Pardue Roy S · Clifton, VABuilt 1973 · S/N 92-73N57424Wood Flying Inc · Panhandle, TXBuilt 1973 · S/N 499-73N57428Zygomalas Stefanos · San Francisco, CABuilt 1973 · S/N 370-73N5742DHemminger Blair · Gwinner, NDBuilt 1956 · S/N 22-4442N5742UAdams Sara · Leavenworth, KSBuilt 1970 · S/N 28-26562N5742WJohnson Ronald H · Goodlettsville, TNBuilt 1963 · S/N 28-1428N5742YAustin Mario A · Charlotte Amalie, VIBuilt 1965 · S/N 27-2867N5742ZBootz Terry A · Canyon Lake, TXBuilt 1984 · S/N 24-1451N57433Propwash LLC · Princeville, ILBuilt 1973 · S/N 88-73N57435Morkassel Gerald N · Waverly, OHBuilt 1973 · S/N 374-73N57442Whiting Lawrence M · Silverton, ORBuilt 1973 · S/N 506-73N57446Williams Martin · Wasilla, AKBuilt 1973 · S/N 507-73N57447Hicks Richard Ted · Statesville, NCS/N 263-73N5744DDempsey Timothy P · Pacific, MOBuilt 1956 · S/N 22-4444N5744ULance Sylvia · Acushnet, MABuilt 1970 · S/N 28-26564N5744WGarrett Jackson Trustee · Pleasant Garden, NCBuilt 1963 · S/N 28-1447N57454Ck Leasing Services LLC · Wilmington, DEBuilt 1973 · S/N 90-73N57456Marshall James I · Roosevelt, UTBuilt 1973 · S/N 508-73N57458Flytrek3 LLC · Palmer, AKBuilt 1973 · S/N 509-73N5745PMiller Aaron T · New Braunfels, TXS/N 24-819N5745QHuseman Joseph F · De Witt, IABuilt 1965 · S/N 3159N5745UMccormick Todd L · Ankeny, IAS/N 28-26565N57468Lease Gregory C · Grand Rapids, MNBuilt 1973 · S/N 514-73N5746PYinyan Tech US Inc · Brea, CANon-citizen corporation, flight hours not reportedBuilt 1959 · S/N 24-820N5746QKing Jeremy · Sandy Springs, GAS/N 3075N5746USale Reported · Crystal, MNSale reportedBuilt 1969 · S/N 28-26567N5746YM C Flyers Inc · Port Orange, FLBuilt 1965 · S/N 27-2871
Back to AD 87-10-06 R1