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.

N765BDukerson Air LLC · Broken Arrow, OKBuilt 2003 · S/N E-3494N765CFCs Air LLC · Osage Beach, MOBuilt 1987 · S/N TH-1528N765TJohnson Adam D · Denton, TXS/N E-404N765WFKofel Aviation LLC · Clayton, GABuilt 1974 · S/N TH-523N766DBWhelan And Associates Pllc · Eagle, COBuilt 1980 · S/N EA-98N766TDecesare George D · Danville, CABuilt 1973 · S/N D-9445N7671GPremier Aviation LLC · Philadelphia, MSBuilt 1980 · S/N E-1671N76747Walter Timothy Andrew · San Rafael, CABuilt 1979 · S/N EA-41N767ARMontenecourt Aviation LLC · Wilmington, DEBuilt 1984 · S/N TH-1407N767CMValiair Lc Trustee · Casper, WYBuilt 1992 · S/N E2723N767DFMaurin Edward E III · Grand Junction, COBuilt 1988 · S/N E-2403N767FAQualitair LLC Trustee · MichelstadtBuilt 1981 · S/N TE1188N767JCCole Jeffrey E · Rockwall, TXS/N E-797N767JPPicard Philip A · Clover, SCBuilt 1990 · S/N TH-1583N767PCIrbf Corporation · Wilmington, DEBuilt 1970 · S/N TE-770N769ACAircraft Propulsion Leasing LLC · Holland, OHBuilt 1978 · S/N TK-89N769TPatterson David Roy · Lockney, TXBuilt 1972 · S/N D-9395N769XXBallard Aviation Inc · Newton, KSBuilt 1980 · S/N CE-885N76ACTennessee Aviation Company LLC · Knoxville, TNBuilt 1980 · S/N E-1791N76BAWestphal Jon A · Menomonie, WIBuilt 1975 · S/N E-783N76DBAek Property 6 LLC · Glendale, AZBuilt 1975 · S/N CE-608N76NB12 Parsecs LLC · Manhattan, KSBuilt 1975 · S/N E-791N76VCBel Air Holdings Inc · Wilmington, DEBuilt 1982 · S/N TH-1361N770LAGulf Airbatics Ltd · Jennings, LABuilt 1974 · S/N TH-517N770MPPerrin Michael G · Howell, MIBuilt 1977 · S/N CE-713N770PMachin Susan M Trustee · Newport Coast, CABuilt 1975 · S/N E-749N770THoyer Kyle E · Manassas, VABuilt 1972 · S/N D-9396N77100Nodine John · Leicester, NCBuilt 1980 · S/N TE-1184N771BB406 Mountain Air LLC · Bigfork, MTS/N EA619N771HEN771he LLC · Hillsborough, NJBuilt 1986 · S/N E-2325N771MAgs Leasing Services LLC · Shoreview, MNBuilt 1971 · S/N E-293N771TFudge Justin · Karnes City, TXBuilt 1972 · S/N D-9415N7724MFallonair Inc · Huntington, NYBuilt 1985 · S/N E2222N772DBAtb Aviation LLC · Wilmington, DEBuilt 2000 · S/N E-3314N772DDN36be LLC · Wilmington, DEBuilt 1993 · S/N E-2775N772MCayle Jonathan · Rochester, MIBuilt 1979 · S/N EA-14N772MDMary Rabbit LLC · Saratoga, CABuilt 1997 · S/N EA-605N772RMaverick Bills LLC · Wilmington, DEBuilt 1980 · S/N CE-912N7733ADvb Enterprises Inc · Colcord, OKBuilt 1988 · S/N CE-1261N773MSWild Blue Yonder LLC · Lees Summit, MOBuilt 1973 · S/N CE-472N774BDDavis III Robert F · Longview, TXBuilt 1981 · S/N E-1868N7758BMiller Jeffrey A Trustee · Tucson, AZBuilt 1982 · S/N TJ-394N775TSorensen Craig A · Fallon, NVBuilt 1974 · S/N D-9664N775VCAmaria Marzban Keki · Riverside, CABuilt 1992 · S/N CE-1704N775ZHundal Medical Corp · Malibu, CABuilt 1980 · S/N TJ283N776DADavisair Inc · Raleigh, NCBuilt 1993 · S/N TH-1697N776WCWingtip Corporation · Valparaiso, INS/N TH-570N776YDRapp Larry · Elbow Lake, MNBuilt 1988 · S/N E-2463N777AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1976 · S/N E-899N777BAGado Theodore A · Cortlandt Manor, NYBuilt 1972 · S/N D-9408
Back to AD 87-18-06 R1