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.

N841JWScenic Concepts LLC · La Crosse, WIBuilt 1974 · S/N 17264340N841LSAnderson Paul N · Edmond, OKBuilt 2004 · S/N 80489N841NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881308N841NHMarrs Matt · Bentonville, ARBuilt 2020 · S/N P07-16N/17N-P011N841PGeeslin James W Jr · Sterling, AKBuilt 1985 · S/N 96N841PSLivin The Dream Aviation LLC · Jupiter, FLBuilt 1967 · S/N 24-4684N841RSVintage Pursuits LLC · Crestwood, KYBuilt 1961 · S/N 3012N841RVPotter Robin B · Southport, NCBuilt 2004 · S/N 24956N841TMJet Aviation LLC · Commerce Township, MIBuilt 2016 · S/N TM01N841WBQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 32R-7887075N84205Mitchell Myron · Advance, NCS/N 83N84209Arwood Ralph Trustee · Naples, FLBuilt 1988 · S/N 85N8420BSplash & Go Seaplanes LLC · Miami, FLS/N 80N8420CRegistered aircraftBuilt 1976 · S/N 28-7690138N8420DAlsworth Glen R Sr · Port Alsworth, AKBuilt 1958 · S/N 22-5675N8420JGimple Herman Wm · Greenville, CABuilt 1980 · S/N VAC-169-80N8420LHayhurst Shane R · Winfield, PABuilt 1968 · S/N 17256620N8420RMueller Lance · Milton, DEBuilt 1966 · S/N 28-22349N8420WMckee Shane D · Fairbanks, AKS/N 28-2647N8420YVanwarmerdam Leslie C · Nampa, IDS/N 18-8862N84210Pm Jets LLC · Ashland, OHBuilt 1969 · S/N 17258380N84214Planefully Obvious LLC · Oshkosh, WIBuilt 1969 · S/N 17258382N84219Manhattan Management Corp · Brooklyn, NYS/N 88N8421AKing Air Inc · Naknek, AKBuilt 1981 · S/N 32-8106085N8421DPutman Bruce C · Leonard, MIBuilt 1957 · S/N 22-5676N8421JRegistered aircraftBuilt 1980 · S/N VAC-166-80N8421RRoberts Darren C · Zionsville, INBuilt 1966 · S/N 28-22298N8421YKesser Gilbert M · Culpeper, VABuilt 1967 · S/N 30-1575N84221Mcknight Michael D · Marietta, GABuilt 1969 · S/N 17258384N84224Cordes Jeffrey A · Happy Valley, ORBuilt 1969 · S/N 17258386N84225Executive Flight Institute LLC · Murrieta, CABuilt 1969 · S/N 17258387N84226Jackson County Aviation LLC · Sneads, FLBuilt 1969 · S/N 17258388N84227Jernigan Alex E · Warrensburg, MOBuilt 1981 · S/N 28-8190298N84229Langenbahn Theodore John · Schoharie, NYBuilt 1969 · S/N 17258389N8422HDeevers Howard A · Tucson, AZBuilt 1981 · S/N 28-8116292N8422LHubert Kim J Trustee · Eagle River, AKBuilt 1968 · S/N 17256622N8422MDymond Mark S · Monterey, TNBuilt 1975 · S/N 28R-7535225N8422NCenter Flying Inc · Lancaster, CABuilt 1981 · S/N 28-8190296N8422PAnderson William · Creve Coeur, ILBuilt 1964 · S/N 24-3672N8422RTascarella William M · Quakertown, PABuilt 1966 · S/N 28-22299N8422W642 Flying Club Of Fort Worth Inc · Fort Worth, TXBuilt 1965 · S/N 28-2649N84234Mazelg Aviation LLC · Bartow, FLBuilt 1969 · S/N 17258390N84235Klj Air LLC · Fairless Hills, PABuilt 1981 · S/N 32R-8113098N8423DKearney Rick G · Amity, PABuilt 1957 · S/N 22-5678N8423LYoung James A · Toledo, WAS/N 17256623N8423PAdams Mark · Sumter, SCBuilt 1981 · S/N 32-8106086N8423WGillanders Kenneth William · Carson City, NVBuilt 1965 · S/N 28-2650N8424Huston Charles D · Austin, TXBuilt 1974 · S/N AGE-150N84243Sjoberg Donald E · Poteau, OKBuilt 1969 · S/N 17258393N8424ATringale Alison · Port Saint Joe, FLBuilt 1981 · S/N 32R-8129092
Back to AD 87-10-06 R1