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.

N3RQAir Carriage Inc · Chico, CABuilt 1972 · S/N 523N3RTVitale James S · Port Orange, FLS/N 75TN3RWGordon George M Jr · Weston, MABuilt 1978 · S/N 17271069N3RXMorelli Michael V · Kenilworth, ILBuilt 1974 · S/N 17264044N3SDDanish John S · Hooksett, NHBuilt 1958 · S/N 24-380N3SFPowers Gilford L · Glenville, NYBuilt 1970 · S/N 17259442N3SGN3sg Enterprises Inc · Wilmington, DEBuilt 1960 · S/N 24-2036N3SHHill Stephen F · Frostproof, FLBuilt 1989 · S/N H-001N3SKMiller Chad L · Shipshewana, INBuilt 1979 · S/N AA5B1219N3SYHigh Planes Aero Club Inc · Longmont, COBuilt 1967 · S/N 670016N3SZWiebens Peter M · Walnut Creek, CABuilt 1989 · S/N 1N3TDDickey Tod V · Phoenix, AZBuilt 1964 · S/N 16N3TFHelicopter Accessory Service East · Pensacola, FLS/N 34-0042N3TNChamplain Flyers LLC · Westford, VTBuilt 1974 · S/N 17263547N3TZCasey Edmond L Trustee · Los Angeles, CABuilt 1968 · S/N 28R-30490N3UGHoffman William C · Mount Pleasant, PABuilt 1977 · S/N 27-7854050N3UVPonderosa Aviation LLC · Safford, AZBuilt 1973 · S/N 3146N3UWRegistered aircraftBuilt 1964 · S/N 28-10341N3VCGreen John T Trustee · Kettering, OHBuilt 1980 · S/N R18201452N3VEAero 356 LLC · Phoenix, AZS/N 3073N3VGInverted Aero LLC · Spring Hill, FLBuilt 1991 · S/N 5198N3VRMckinnon David C · Cornelia, GABuilt 1980 · S/N EE2N3VTFleming Stephen · Los Lunas, NMBuilt 1995 · S/N 21017N3WDMorphew Ben · Mckinney, TXBuilt 1978 · S/N 01N3WPHagar Kevin J · Skiatook, OKBuilt 1961 · S/N 1820N3XEServ Aero Engineering Inc · Salinas, CABuilt 1963 · S/N 30-92N3XHSmith Rodney S · Crawford, COBuilt 2024 · S/N 246N3XJJax Transport LLC · Amarillo, TXS/N 1390N3XKDriscoll David Delory Jr · Milwaukee, WIBuilt 1983 · S/N 002N3XMSmith Michael K · Grass Valley, CABuilt 1996 · S/N B93F96N3XSBrewer Joshua Ryan · Sonora, CABuilt 1996 · S/N C001N3YHarding Mike R · Ventura, CABuilt 1961 · S/N 1N3YBMonroe Andrew P · Reno, NVBuilt 1976 · S/N 76-564N3YMLoftin Scott M · Rosamond, CABuilt 2001 · S/N 3223N3YRStone Charles Douglas · Cedarville, OHBuilt 1975 · S/N 18-7509113N3YSAdams Harry J · New Waverly, TXS/N 916N3YUT2 Aviation LLC · Missouri City, TXBuilt 2004 · S/N 18281453N3ZAMorgan James P · Arlington Heights, ILBuilt 1995 · S/N 0693N3ZRRegistered aircraftBuilt 1973 · S/N 1048N3ZWMicle Florin · Cedar Park, TXS/N 23241N40004Tennesen James B · Menomonie, WIBuilt 1977 · S/N 28R-7737126N40005Williams Brian · Rhinebeck, NYBuilt 1977 · S/N 28-7716312N40006Kotwal Pramod · Bedford, MABuilt 1977 · S/N 28-7716314N40008Birkland Mitchell L · Lake Jackson, TXBuilt 1977 · S/N 28-7716317N4000MDonair LLC · Enid, OKBuilt 1962 · S/N M-90N4000XJp Skyward LLC · Ontario, CABuilt 1998 · S/N 172S8010N4000ZAmstrup Jeremy T · Fairbanks, AKBuilt 1963 · S/N 18-7951N40010Sain Ricky F · Vale, NCS/N 28R-7737127N40014Ar Racing Inc · Catawba, NCBuilt 2025 · S/N 2825N40015Wings Flying Club Inc · Sheperdsville, KYBuilt 1977 · S/N 28-7716319
Back to AD 87-10-06 R1