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.

N4090SByerly Brooks · Plano, TXBuilt 1975 · S/N E-645N4091SBeechcraft Heritage Museum · Tullahoma, TNBuilt 1975 · S/N CE-556N4092TEnnyx LLC · Clermont, FLBuilt 1974 · S/N E-556N4093EDmkr LLC · Coronado, CABuilt 1999 · S/N E-3293N4099SDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N TE-1037N409PDIowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1973 · S/N CE-450N40ABSchumacher Steven Joseph · Fayetteville, ARBuilt 1983 · S/N CE-1020N40FJbk I LLC · Wayne, ILBuilt 1993 · S/N E-2793N40GHagerty Environmental LLC · Kennett Square, PABuilt 1972 · S/N D-9342N40JBElk River Aero LLC · Noel, MOS/N TH-338N40JHJohnson Sean M · Martinez, CABuilt 1975 · S/N E-772N40KGFour Stars Aviation Inc · Mclean, VABuilt 1983 · S/N E-2067N40MWCarbone Peter E Jr · Hopkinton, MAFirst renewal noticeBuilt 1980 · S/N E-1708N40PGFunanich Jon J Trustee · Fairfield, CABuilt 1980 · S/N TJ-309N40TEWild Warbirds LLC · Uvalde, TXS/N CE577N40TRKwong Elwood · Foothill Ranch, CABuilt 1977 · S/N E-1190N40VKelly Donald William Jr · Roswell, GABuilt 1971 · S/N TE-799N40XSSasser F Michael · Cedar Park, TXBuilt 1978 · S/N E-1278N4101PKnepp Terry Wayne · Montgomery, INBuilt 1977 · S/N E-1026N4102SFlying Drahthaar LLC · Billings, MTBuilt 1975 · S/N TE-1038N4103SSky High Aviation LLC · Fishers, INBuilt 1975 · S/N TE-1039N4104SSky West Aviation Inc Trustee · Albuquerque, NMS/N CE-558N4104T4a Legacy Enterprises LLC · Mcallen, TXBuilt 2001 · S/N E-3411N4106SCompnet Solutions Inc · Dallas, TXBuilt 1975 · S/N CE-559N4107SAnnamar LLC · Wilmington, DEBuilt 1975 · S/N D-9735N4108GKimberk Frederick S · Cambridge, MABuilt 1971 · S/N TH-166N4108SBto Aviation LLC · Eden Prairie, MNBuilt 1975 · S/N TH-605N410DRJmsat Corp · Moneta, VABuilt 1977 · S/N TK52N410HAWalega Jane Ellen · Essex, MDBuilt 1982 · S/N E-2035N410LJBednar David · Norwalk, IABuilt 1982 · S/N EA293N410PCBohnert Matthew · Bend, ORBuilt 1976 · S/N TJ-48N410RWButler National Inc · New Century, KSBuilt 1982 · S/N E-2031N410T410t LLC · Kennett Square, PABuilt 1988 · S/N CE-1239N4111SKnowles Warren R · Ocean City, NJS/N TJ-4N4114SHeffernan Duane C · Moravia, NYS/N CE-434N4115SDanielson Adam M · Chassell, MIS/N TH-644N4118SStevens Ronald D · Boise, IDFirst renewal noticeBuilt 1975 · S/N CE-563N411GJGuardian Jet LLC · Guilford, CTBuilt 1990 · S/N E-2586N411JGKern County Aviation Leasing LLC · Bakersfield, CABuilt 1986 · S/N EA-461N411LNathan David L DBA · Fullerton, NEBuilt 1974 · S/N TE-976N411MLRosner Louis M · Port Orange, FLBuilt 1972 · S/N E-308N4121XSignature Remodeling LLC · Boonville, MOBuilt 1975 · S/N E-651N4124SAvondale Aviation LLC · Park Ridge, ILBuilt 1975 · S/N E-653N4124WGeaux Automotive Advertising LLC · La Place, LABuilt 2000 · S/N TH-1943N4127SKrall Jeff P · Mitchell, SDBuilt 1975 · S/N D-9738N412DPickens Ray T · Pleasanton, TXBuilt 1974 · S/N TH-464N412YMurrieta Humberto · San Antonio, TXS/N D-9292N4130SYakish S Dale · Wexford, PABuilt 1975 · S/N TH-612N4134SQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N TJ-18N4135SRazzyfish Inc · Colton, CABuilt 1975 · S/N D-9787
Back to AD 87-18-06 R1