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.

N5505UPaper Plane Aviation LLC · Avon Park, FLBuilt 1969 · S/N 28-26215N5505WPerez Daniel E · Parsons, KSBuilt 1962 · S/N 28-592N55064Western Skyways Inc · Montrose, COBuilt 1973 · S/N 28-7325317N55065Lynch Timothy B · Aguadilla, PRBuilt 1978 · S/N 427-78N55066Premier Capital Enterprises LLC · Hurricane, UTS/N 28-7305303N55067Hinsch Delano G · Larchwood, IABuilt 1978 · S/N 428-78N55069Tre Aviation Corp · Wilmington, DEBuilt 1973 · S/N 28R-7335177N5506JSoaring For Christ LLC · Big Lake, AKBuilt 1968 · S/N 32-1051N5506LKoster Michael Richard · Plano, TXS/N AA5-0506N5506MCloud Kicker Aviation LLC · Kalamazoo, MIBuilt 1978 · S/N 1040-78N5506UHumberto Moreno · Mulberry, FLBuilt 1969 · S/N 28-26214N5506WMchatton Dret A · Redding, CABuilt 1962 · S/N 28-593N5506ZOakcrest Management Inc · Brownsville, TXBuilt 1978 · S/N 364-78N55075Paris Air Inc · Vero Beach, FLS/N 34-7350170N55078Tiritilli Robert · Mission Viejo, CABuilt 1973 · S/N 28-7325320N5507LFletcher Alex J · Weston, WIBuilt 1974 · S/N AA5-0627N5507PMccleskey Nicholas J · Mcminnville, ORBuilt 1978 · S/N 1043-78N5507WBurnett Fred · Greenbrier, ARBuilt 1978 · S/N 365-78N55080Keath Brian S · Kansas City, MOBuilt 1973 · S/N 28-7305305N55087Fosso Christopher M · Glendale, AZBuilt 1973 · S/N 28-7305308N55089Zitren Frederick J · El Cajon, CABuilt 1973 · S/N 32-7340100N5508JPaetzold Larry E · Brownwood, TXBuilt 1978 · S/N 1048-78N5508LDe Lint Marcus W · Cove, ORBuilt 1978 · S/N 1049-78N5508QSchmidt James A · Richmond, VABuilt 1965 · S/N 707N5508WEkkel Bob J · Newaygo, MIBuilt 1962 · S/N 28-596N55094Remedy Aviation LLC · Langford, SDBuilt 1973 · S/N 28-7325322N55096Robinson Jeffrey M · Scottsboro, ALBuilt 1973 · S/N 28-7305311N5509FAhs Aero LLC · Leo, INS/N 28-24850N5509JJet Air Inc · Iowa City, IABuilt 1980 · S/N 17273810N5509QCarlson Jeremy Nathaniel · Arnold, CABuilt 1965 · S/N 2943N5509WKitts John L · New Braunfels, TXBuilt 1962 · S/N 28-597N550DBHarding Mason · Phoenix, AZBuilt 1992 · S/N 539N550DEJanay Jesse A · Charlottesville, VABuilt 1998 · S/N 2656N550EEEidal Peter M · Kent, WABuilt 2014 · S/N 82123N550FLKennedy Adam B · Des Moines, WAS/N 28-7125387N550JSBawk Aviation LLC · Xenia, OHBuilt 1977 · S/N R18200105N550PWhitmus Christopher A · Bowie, TXBuilt 2003 · S/N 3114N550PEHeller Ross S · Gig Harbor, WAS/N 550N550PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842106N550WHAlligator Inc · Lawrence, KSBuilt 1989 · S/N HAMSA/ROHDE0001N5510FHughes Arlen L · Saratoga, WYBuilt 1968 · S/N 28-24851N5510QN407ml LLC · Wilmington, DEBuilt 1965 · S/N 608N5510WMilius Douglas L · Oshkosh, WIBuilt 1962 · S/N 28-598N55115Gleason Ronald L · Willows, CAS/N 28-7305313N55116Stick And Rudder Aviation LLC · Hale, MOBuilt 1973 · S/N 28R-7335182N55117Smathers Jason R · Redwood City, CABuilt 1973 · S/N 28-7310116N5511ABuller Paul W · Laguna Hills, CABuilt 2002 · S/N 23076CN5511FSmith Jimmy A Jr · Albemarle, NCBuilt 1968 · S/N 28-24852N5511GQualitair LLC Trustee · MichelstadtBuilt 2001 · S/N 26014CN5511PGear Down Hangar LLC · Phoenix, AZBuilt 1958 · S/N 24-574
Back to AD 87-10-06 R1