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.

N67230Boomerang Air LLC · Cedar Park, TXBuilt 1983 · S/N E-2093N67249Derasmo Dominick · Manteo, NCBuilt 1983 · S/N CE-1022N6724TKaufman Melissa R · Franklin, TNBuilt 1984 · S/N E-2163N6724VFlying Bevo LLC · Newark, DEBuilt 1983 · S/N E-2095N67255Beau Air LLC · Edwards, COBuilt 1983 · S/N EA-374N6725CVick David L · Fort Jones, CABuilt 1983 · S/N EA-373N6725TQuitman LLC · Spartanburg, SCBuilt 1984 · S/N TH-1423N6725VAdvanced Thermal Systems Inc · West Memphis, ARBuilt 1983 · S/N E-2098N6726DDefini John · Mooresville, NCS/N E-2097N6726SSchaney Michael W · Brookville, OHBuilt 1983 · S/N TH-1390N6727SKt Aero LLC · Charleston, WVBuilt 1983 · S/N E-2100N6727VUnited States Aviation Consultants LLC · Davie, FLS/N EA-378N6728FPeters Bruce L · Wichita, KSBuilt 1983 · S/N EA-379N6728LHancock Aircraft Sales LLC · Baton Rouge, LAS/N TH-1095N6728RRegency Horizons Group LLC · Middletown, DEBuilt 1983 · S/N EA-380N6728VDriftwood Creek Flying Club LLC · Yankton, SDBuilt 1983 · S/N E-2103N6728YDashdale Aviation LLC · Fort Dodge, IABuilt 1980 · S/N D-10330N6728ZMccrorie LLC · Helena, MTBuilt 1980 · S/N EA-57N67290Price Edward Rollins Vii · Elon, NCBuilt 1980 · S/N TH-1108N6729ZMiddle Tennessee Aircraft Services LLC · Mount Pleasant, TNBuilt 1980 · S/N TH-1109N6731RHaidlen Ford Inc · Oakdale, CABuilt 1980 · S/N D-10331N6731ZJerry Slough Aviation LLC · Bakersfield, CAFirst renewal noticeBuilt 1980 · S/N TJ-255N6732ZAir Pear LLC · Yakima, WAS/N E-1647N6733BWallace Scott D · Fairfield, CAS/N CE-919N6733MWilson Lawrence J · West Sacramento, CABuilt 1979 · S/N EA-37N6733YThormann Braulio Federico Cosme · Hollis Hills, NYBuilt 1980 · S/N CE-927N67343Gray Reece Allen · Buna, TXBuilt 1980 · S/N E-1649N6734UR E Bentz Inc · Monroe, LAS/N TK-117N6734XGood Deal Charlie Inc · Russellville, ARBuilt 1980 · S/N TH-1116N67352Ascension Aviation LLC · Gaylord, MIBuilt 1979 · S/N TH-1098N67353Registered aircraftBuilt 1983 · S/N E-2105N6735PTarvin Darrel D · Huntsville, TXBuilt 1983 · S/N E-2104N6735ZGta Air Inc · Addison, TXBuilt 1979 · S/N E-1605N6736GKough Bryan · Scott City, KSBuilt 1980 · S/N E-1648N6736NSalter Aviation LLC · Bowdon, GABuilt 1980 · S/N E-1695N6736SA36 Aviation LLC · Boise, IDBuilt 1982 · S/N E-1987N6736TBrakke Thomas · Clear Lake, IABuilt 1981 · S/N EA-242N6736VSharkey Lowell G · Manitou, KYBuilt 1979 · S/N E-1569N6737DMarlin Air LLC · Dallas, TXBuilt 1980 · S/N E-1651N6737VRiverview Ranches · Chowchilla, CAS/N EA-63N6739CPearce William · Grants Pass, ORBuilt 1980 · S/N TJ-262N6739TJoca Holdings LLC · Kittrell, NCBuilt 1980 · S/N E-1652N6739UKahler Automation Corp · Fairmont, MNBuilt 1979 · S/N E-1591N6739WSweigard Daniel J · Euless, TXBuilt 1980 · S/N CE-899N673CVNewton Donald O Jr · Gretna, NEBuilt 1977 · S/N CE-738N673HPBk Investment Co LLC · Jupiter, FLBuilt 1982 · S/N TH-1326N67414Staley Clifford D · Delray Beach, FLBuilt 1980 · S/N E-1661N6741DPerformance Aircraft C LLC · Litchfield Park, AZBuilt 1983 · S/N TH-1395N6741MCooper Aviation LLC · Georgetown, SCBuilt 1980 · S/N TK-122N6741WDempsey Justin · Hazlet, NJBuilt 1980 · S/N E-1660
Back to AD 87-18-06 R1