OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,413

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-08-08-R3')
    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-08-08-R3')
  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.

N44990Fineran James V III · Towson, MDBuilt 1977 · S/N 32-7840002N44995Fenton Flyers LLC · Ellisville, MSS/N 28R-7703352N44996Executive Flyers Inc · Sacramento, CABuilt 1977 · S/N 28-7816054N4499JWiblemo Craig B · Fallbrook, CABuilt 1967 · S/N 28-22920N4499WUrban James R · Pierre, SDBuilt 1965 · S/N 28-2911N4499XCitrus Flight LLC · Lecanto, FLBuilt 1975 · S/N 32R-7680021N449AArcher Aero LLC · Wilmington, DEBuilt 2014 · S/N 2843798N449DWWalt David L · Clarkston, MIFirst renewal noticeBuilt 1977 · S/N 28R-7703349N449DYRanjit Pearlinda · Apex, NCBuilt 1972 · S/N 28R7235200N449RMRocky Mountain College · Billings, MTBuilt 2024 · S/N 28020198N44AYPartin Kathy L · Nacogdoches, TXS/N 28R-7535012N44DZWanted Poster Owners Group LLC · York, PABuilt 1973 · S/N 32-7300046N44FTPenner Hope E · Placentia, CAS/N 28-7716219N44JAJersey Aero Club Inc · Lakewood, NJBuilt 1983 · S/N 32-8306031N44JYAcre LLC · Abilene, KSBuilt 1969 · S/N 32-40637N44KDSale Reported · Crystal, MNSale reported, canceledBuilt 1972 · S/N 28R-7235106N44PFVaayu Aviation LLC · Newark, CABuilt 1970 · S/N 28-26800N44PWWeber Peter III Trustee · Loudon, TNBuilt 1979 · S/N 28-8090147N44SMHinds Community College · Raymond, MSBuilt 1976 · S/N 28R-7635076N44VVHampton Warrior II Inc · Shelter Island, NYBuilt 1980 · S/N 28-8116009N4500FEngle David · Memphis, TNBuilt 1976 · S/N 32R-7680455N4500RWork Edward · Sneads Ferry, NCBuilt 1965 · S/N 28-21199N4501JBleem Steven L · Duncan, OKBuilt 1968 · S/N 28R-30355N4501RNess James H · Phoenix, AZBuilt 1965 · S/N 28-21200N4503FWilliams Edwin H · Edgecomb, MEBuilt 1976 · S/N 28-7725018N4503JSkykid Adventures LLC · Cedar Valley, UTBuilt 1968 · S/N 28R-30358N4505FSeeley Dwayne · Dover, DEBuilt 1976 · S/N 28-7715042N4505RFayal Kenneth E Jr · Bend, ORS/N 28-21205N4505XBlack Hound Aviation LLC · Austin, TXBuilt 1975 · S/N 32R-7680022N4506RCruz Roberto Jr · Douglasville, GABuilt 1965 · S/N 28-21206N4506TPettit Kenneth W · Madison, INBuilt 1972 · S/N 28-7225176N4506VRegistered aircraftBuilt 1979 · S/N 28-8090026N45077Qualitair LLC Owner Trustee · MichelstadtBuilt 1978 · S/N 28-7911291N4507JSkvara Stanley Henry Jr · Parma, OHBuilt 1968 · S/N 28R-30363N4507NGarnet Aviation LLC · Fort Worth, TXBuilt 1979 · S/N 28-8090031N4507QFrost Aviation Services Inc · Las Cruces, NMBuilt 1979 · S/N 28-8090032N4507RFly First LLC · West Memphis, ARBuilt 1979 · S/N 28R-7918246N4507TLoma Aviation LLC · San Diego, CABuilt 1972 · S/N 28-7205174N4507XVanny Ravy · Winchester, CABuilt 1976 · S/N 28-7625046N4507YEmanuels Adam C · Selma, NCBuilt 1979 · S/N 28-7911290N4508JWood Daniel W · Cottonwood Shores, TXBuilt 1968 · S/N 28R-30364N4508RMcmichael Timothy J · Rock Hill, SCBuilt 1979 · S/N 32-7940245N4508XWestchester Flying Club Inc · Purchase, NYBuilt 1975 · S/N 28-7690026N4509XPerformance Power Services Pc · Naperville, ILBuilt 1975 · S/N 28R-7635067N450AACentex Aero LLC Trustee · San Antonio, TXBuilt 2019 · S/N 2881256N450CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881122N450FLMorriss Aviation LLC · Allen, TXBuilt 1971 · S/N 28-7125243N450JDJd Dakota Leasing LLC · Stuart, FLBuilt 1978 · S/N 28-7911017N450ZRCasey William · Celina, TXBuilt 2021 · S/N 2881481N4510DCamwhit Air Corp · Montgomery, NYBuilt 1979 · S/N 28-8016015
Back to AD 87-08-08 R3