OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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-18-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-18-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.

N81VBNeal Foster Trucking Inc · Merrill, ORBuilt 1980 · S/N D-10315N81VTDouble D Aircraft LLC · Sergeant Bluff, IABuilt 1974 · S/N D-9640N81WMPaladin Aircraft Restoration Inc · Monticello, UTBuilt 1977 · S/N CE-739N81WRGreen Donald · Batesville, TXBuilt 1981 · S/N TE-1192N8201ETigre Air LLC · Missoula, MTBuilt 1993 · S/N E-2777N8204MBlue Sky Flying Club LLC · Granger, IABuilt 1991 · S/N E-2667N8209ARocky Top Real Estate Investments LLC · Paola, KSBuilt 1993 · S/N E-2781N820BRSkywood Aviation LLC · Wayne, NJBuilt 1996 · S/N E-3011N820GHMcdavitt Edward T · Sugar Land, TXBuilt 1994 · S/N E-2870N820VNovember 820v LLC · Fitchburg, WIBuilt 1995 · S/N E-2947N8215MJnk Equipment LLC · Deer Harbor, WABuilt 1993 · S/N EA-548N821GHN821gh LLC · Hudson Oaks, TXBuilt 1994 · S/N E-2871N821VOldfield Corwyn D · Visalia, CABuilt 1977 · S/N E-1100N8220FCegnar Ron W · Lexington, KYBuilt 1991 · S/N CE-1581N8220MHampshire Aviation Inc Trustee · Wilmington, DEBuilt 1993 · S/N E-2795N8224JMassingill Lynn · Gatesville, TXBuilt 1991 · S/N CE-1594N8228ZSquare Cube Flying Inc · San Diego, CAS/N E-2800N822GSBall John E · Barboursville, WVBuilt 1973 · S/N TE-916N822TMarburger James H · Phoenix, AZBuilt 1973 · S/N D-9513N8230YVasel Randolph L · Greenville, ILBuilt 1991 · S/N CE-1601N8231LTamboer Leonard · Cave Creek, AZS/N CE-1604N8232KSherman Mark D · Port Orange, FLBuilt 1991 · S/N CE-1605N8233JMunstead Hollow Farm LLC · Downington, PAS/N CE-1528N8234MFontenot Shane B Dr · Jennings, LABuilt 1991 · S/N EA-520N8236ESpringdale Ventures LLC · Ocala, FLBuilt 1993 · S/N E-2779N8236UHarris Adam K · Shrewsbury, MABuilt 1991 · S/N E-2677N8237JWilcox Christopher M · Jay, OKBuilt 1991 · S/N E-2670N823EFViperhawks LLC · Jacksonville, FLBuilt 2001 · S/N TH-1986N823LAN907ds LLC · Palo Alto, CABuilt 1997 · S/N E-3129N823PCLester Jon M · Lancaster, OHBuilt 1987 · S/N CE-1161N823RDJojabella LLC · Jonesboro, ARBuilt 1995 · S/N TH-1741N823TKnight Koby Ernest · Haslet, TXS/N D-9521N823VUsher James C · Fort Worth, TXBuilt 1976 · S/N D-9872N8240TKolotushkin Igor · North Hills, CABuilt 1990 · S/N CE-1542N8241KBlytheair LLC · Laguna Hills, CABuilt 1991 · S/N CE-1616N8241NSpecial Services LLC · Magnolia, DEBuilt 1991 · S/N EA-522N8242JRegistered aircraftBuilt 1991 · S/N E-2676N8242TN8242t LLC · Phoenix, AZBuilt 1991 · S/N CE-1610N8245DBrozenske Donald A Trustee · Wenham, MABuilt 1991 · S/N CE-1570N8245JSln Aviation LLC · Salina, KSBuilt 1991 · S/N E-2650N8246VCaliber Construction Inc · Columbia, KYBuilt 1991 · S/N CE-1620N8247AQuality Kiln & Dryer Inc · Oakdale, LABuilt 1991 · S/N CE-1625N8248BSmith Kirk A · Searcy, ARBuilt 1991 · S/N TH-1633N8248KPlane Haven LLC · Kalispell, MTBuilt 1991 · S/N E-2678N8250RM O S T Express · Franklin, TNS/N CE-1734N8252TRegistered aircraftBuilt 1990 · S/N CE-1545N8253CAl Stevens Construction LLC · Overland Park, KSBuilt 1990 · S/N CE-1546N8253NTejas Aviation Services LLC · Wilmington, DEBuilt 1993 · S/N CE-1743N8254DWest Pacific Air LLC · Spokane, WABuilt 1991 · S/N EA-524N8255ESouth Road Partners Inc · Kentfield, CABuilt 1991 · S/N CE-1630
Back to AD 87-18-06 R1