OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,430

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.

N1807TCharles P Graef Inc · Montchanin, DEFirst renewal noticeBuilt 1971 · S/N 28-7125160N1809HAviation Consulting Expertise LLC · Fairfax Station, VAS/N 28-7790314N1809TAudilet Brett Y · Liberty, TXBuilt 1971 · S/N 28-7125162N180ACDupont Cody C · Allison, TXBuilt 1969 · S/N 28-5653N180BVGarcia Karin M · Richland, WAS/N 28-4161N180CCMorrison Gerald L · Kansas City, MOBuilt 1974 · S/N 28-7505048N180CQKehoe William R · Port Clinton, OHBuilt 1973 · S/N 28-7305306N180CVN Registration Service LLC Trustee · Sanford, NCBuilt 1968 · S/N 28R30693N180DPHarvey Marjory J Trustee · King George, VABuilt 1969 · S/N 28-5457N180EGroom Lucas W · Williamsburg, VABuilt 1969 · S/N 28-5373N180EBWachholz James A · Two Rivers, WIBuilt 1965 · S/N 28-2858N180LKBoston Commercial Corp Trustee · Wilmington, DEBuilt 1971 · S/N 28-7105121N180LSSimonson Larry · Dalton, MNBuilt 1969 · S/N 28-5616N1811JJonas Christian R · Corpus Christi, TXBuilt 1968 · S/N 28-24239N1812JEcho Aviation II LLC · Akron, OHBuilt 1968 · S/N 28-24240N1813JSale Reported · Princeton, MNSale reportedBuilt 1968 · S/N 28-24242N1814JGunn John R · Eloy, AZBuilt 1968 · S/N 28-24243N1815JDodson International Parts Inc · Rantoul, KSBuilt 1968 · S/N 28-24244N1816TGq Aviation LLC · Cherry Hill, NJBuilt 1971 · S/N 28-7125173N1817JCarey Thomas W Jr · Springfield, ILBuilt 1968 · S/N 28-24247N1817TR J Services LLC · Centerton, ARBuilt 1971 · S/N 28-7105142N1818JDavey Aaron A · Topeka, KSBuilt 1968 · S/N 28-24248N1818TCopp Gary P · Carson City, MIBuilt 1971 · S/N 28-7105143N181AEDavis Timothy Alan · Huntsville, ALBuilt 1977 · S/N 28-7890235N181AVElkins Pilots Club · Elkins, WVBuilt 1979 · S/N 287990269N181BAClough James Erwin · Pittsboro, NCBuilt 1981 · S/N 28-8116230N181BHAeronation Aircraft & Exotics LLC · Lewes, DEBuilt 1982 · S/N 28-8390003N181DJNew England Aviation LLC · Plainville, CTBuilt 1977 · S/N 28-7790415N181DP181dp Aircraft Leasing LLC · Spanish Fork, UTS/N 28R-7335246N181DWNorthern Aviation LLC · Palmer, AKS/N 32R-7680440N181FATriangle Aviators LLC · Cary, NCBuilt 1983 · S/N 288390062N181FCFlightstar Corp · Savoy, ILBuilt 2000 · S/N 2843316N181GBBartel Gary W · Tucson, AZBuilt 1979 · S/N 28-7990275N181GPPilots Flying School LLC · Manalapan, NJBuilt 1984 · S/N 28-8490061N181HEOzziac Enterprises Inc · Huron, OHBuilt 1988 · S/N 2890078N181KCGillette Investing LLC · Sioux City, IAS/N 32R-8129055N181LSLee Jerry R · Fresno, CABuilt 1999 · S/N 2843227N181MHHurd Mark A · Bono, ARBuilt 1979 · S/N 28-7990279N181MRAverett University · Danville, VABuilt 1999 · S/N 2843223N181PDAnderson Christopher · Wilmington, NCBuilt 1978 · S/N 28-7890462N181PGSkybound Aviation LLC · Kernersville, NCBuilt 1977 · S/N 28-7790584N181RJUaa International Inc · La Verne, CABuilt 1980 · S/N 28-8190106N181TBVector Aviation LLC · Mentor, OHBuilt 1978 · S/N 28-7990212N181TCDezendorf Thomas C · Petaluma, CABuilt 1979 · S/N 28-7990324N181TKAnderson Brad A · Rochester, MNBuilt 1977 · S/N 28-7890193N181TPOssowski Gerald A · Orland Park, ILS/N 28-7790426N181TSJls Aviation LLC · Sarasota, FLBuilt 1975 · S/N 28-7690062N181WFNorton Thomas W · Dayton, NVBuilt 1977 · S/N 28-7890116N181WGFlycasual LLC · Bloomington, ILBuilt 1984 · S/N 28-8490069N181WMWozniak David D · Greenfield, MABuilt 1973 · S/N 28-7405060
Back to AD 87-08-08 R3