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.

N5779FScheer Abraham · Milton, DEBuilt 1968 · S/N 28-25085N5779PLechner Kevin P · Wurtsboro, NYBuilt 1959 · S/N 24-858N577BASpitzer Helicopter LLC · Woodland Hills, CABuilt 2002 · S/N 1163N577CMEllison Ranching Co · Elko, NVBuilt 1977 · S/N 18-7709134N577DPLustfeldt Gordon L · Normal, ILBuilt 1959 · S/N 24-848N577FLMorsi Sameh M · Pomona, CABuilt 1971 · S/N 28-7125428N577GTInternational Air Services Inc Trustee · Carson City, NVBuilt 2025 · S/N MXS-004N577JHLlopis USA LLC · Rockledge, FLBuilt 1999 · S/N 27-0281N577JLJaj Aviation LLC · Plano, TXS/N 577N577SPTexas State Technical College · Waco, TXBuilt 2000 · S/N 172S8503N577TMoore Eric C · Cave Creek, AZBuilt 1988 · S/N 01N577TZWestbank Fishing LLC · Kiln, MSBuilt 2002 · S/N 18281123N5780FAces Aviation LLC · Laurel, MTS/N 28-25087N5780PWall Scott · Franksville, WIBuilt 1959 · S/N 24-859N5780QMuegge Erik L · Keller, TXBuilt 1965 · S/N 3092N5780WSmoyer Justin L · Slatington, PABuilt 1964 · S/N 28-1657N57816North Texas Dusters & Sprayers Inc · Gainesville, TXS/N 36-7660122N5781FRegistered aircraftBuilt 1968 · S/N 28-25088N5781QFranklin Mountain Group Corp · Nashville, TNBuilt 1965 · S/N 749N5781WPietras Aaron E · Franklin, INBuilt 1964 · S/N 28-1658N5782FMission Aviators LLC · Spring, TXBuilt 1968 · S/N 28-25089N5782JN5782j LLC · Myrtle Beach, SCBuilt 1979 · S/N 17273835N5782PPaviation LLC · Lewes, DEBuilt 1959 · S/N 24-861N5782QSkylions LLC · Wichita, KSBuilt 1965 · S/N 3093N5782VDave Sheets And Sons Contracting Inc · Columbia City, INBuilt 1966 · S/N MA-41N5782WDavis Clinton · Baldwin City, KSBuilt 1964 · S/N 28-1659N57830Mid Continent Aircraft Corp · Hayti, MOBuilt 1977 · S/N 36-7760003N57832Sherer Robert O · Hayes, SDBuilt 1977 · S/N 36-7760005N5783FBate Eric D · Vancouver BcBuilt 1976 · S/N 28-7725066N5783ULindberg Kyle J · Pahrump, NVBuilt 1970 · S/N 28-26607N5783WDillard Joseph · Thaxton, MSBuilt 1964 · S/N 28-1660N57846Boardman Air Services LLC · Henderson, NEBuilt 1977 · S/N 36-7760017N5784FCrocker James Fuller · Trussville, ALBuilt 1968 · S/N 28-25090N5784PMiller Jeffery Allen · Menifee, CAS/N 24-863N5784QArias Raymond G · Wesley Chapel, FLS/N 3094N5784UMchenry Charles · Siloam Springs, ARBuilt 1970 · S/N 28-26608N57859Airmotive Service LLC · Brigham City, UTBuilt 1977 · S/N 36-7760029N5785PSmith Clyde R Jr · Lock Haven, PABuilt 1959 · S/N 24-864N5785QSw Industry Inc · Wilmington, DEBuilt 1965 · S/N 751N5785UZanino James A · Sterling, MABuilt 1970 · S/N 28-26609N5785WLilu LLC · Siloam Springs, ARBuilt 1964 · S/N 28-1671N5786FPalazzi Michael A · Longmeadow, MABuilt 1968 · S/N 28-25094N5786PMckowan Sheila R · Chatsworth, CAS/N 24-865N5786QMartinez Todd P · Vacaville, CABuilt 1965 · S/N 3095N5786UCampbell Ashley H · Colorado Springs, COBuilt 1969 · S/N 28-26611N5786WPowers Meranda M · Nampa, IDBuilt 1964 · S/N 28-1676N5787BWilliams Thomas C · Fort Myers, FLBuilt 2003 · S/N 90111N5787DWyoming Development LLC · Cheyenne, WYBuilt 1960 · S/N 1623N5787UCodreanu Octavian · Thorndale, PAFirst renewal noticeBuilt 1969 · S/N 28-26612N5787WNewsome Robert K · Linwood, NCBuilt 1964 · S/N 28-1680
Back to AD 87-10-06 R1