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.

N5150EM & M Aviation Enterprises LLC · Springfield, MOS/N E-3412N515EKSolomon Paul T · Cleburne, TXBuilt 1984 · S/N EA-440N515PDSeals Welding & Fabircating Inc · Oxford, ALBuilt 1990 · S/N CE-1532N515RGDowney Paul J · Newington, NHS/N TH-2108N515RJFroehlich Franz M · Oceanside, CABuilt 1983 · S/N EA-357N515TGMilton Steven Pichon · Houston, TXBuilt 1994 · S/N EA-570N516WClearwater Holding LLC · Parkersburg, WVBuilt 1975 · S/N D9744N5177MElh Aviation LLC · Flint, MIBuilt 1977 · S/N TJ-116N517DJUrquhart Dan DBA · Fallon, NVBuilt 1997 · S/N E-3075N517HAHarrison Aviation LLC · Macon, GABuilt 1984 · S/N E-2175N517KGRegistration Pending · Pittsburg, TXRegistration pendingBuilt 1980 · S/N D10350N517MRDgw Aviation LLC · Elverson, PAS/N TH-2012N517PYYoung Millard Perrin · Raleigh, NCBuilt 1970 · S/N CE-305N518ABVickery Hawk Partners LLC · Fort Worth, TXBuilt 1974 · S/N CE-518N518MMull Jason E · Chester, NYBuilt 1970 · S/N D-9111N518PRodney H Greenway Inc · Niceville, FLS/N E-3483N518YPWs Aviation Group LLC · Washta, IABuilt 1980 · S/N TJ-265N519CMCygnet Aerospace Corp · Los Osos, CAS/N TJ-56N519RRothacker Aviation LLC · Wilmington, DEBuilt 1986 · S/N CE-1083N51ECVesely & Co Inc · Houston, TXBuilt 1995 · S/N E-2983N51FDH2f2 LLC · Prairie Village, KSBuilt 1979 · S/N TH-1075N51MAAch Construction & Properties LLC · Mount Pleasant, TXBuilt 1978 · S/N E-1230N51MLTrek Aviation LLC · Amsterdam, NYBuilt 1997 · S/N E-3105N51MTTrantham Joey L · Panama City, FLBuilt 1985 · S/N TH-1485N51PVCrupi John · Fort Lauderdale, FLBuilt 1987 · S/N CE-1174N51WAPennewell Solutions LLC · Dover, DEBuilt 1973 · S/N CE-452N51WP79ef LLC · Granite Falls, MNBuilt 2003 · S/N E-3508N51YDTj Air Holdings Inc Trustee · Wilmington, DES/N CE-867N520LLMesoamerica Aviation Corp · Wilmington, DEBuilt 2002 · S/N TH-2052N520PKJol Av Inc · Orange Beach, ALBuilt 2000 · S/N E-3365N521CRuhan Brendon Thomas · Rehoboth, MABuilt 1987 · S/N CE-1119N521EAngels Ten LLC · Norfolk, VABuilt 1981 · S/N CE-963N521PWDoghouse Aviation LLC · Vienna, VABuilt 1988 · S/N E-2434N521WSCmt Properties LLC · Laurel, MSBuilt 1997 · S/N TH-1836N523AMSigma Aviation LLC · Vancouver, WABuilt 1981 · S/N E-1723N523CHawk Unlimited LLC · Kalispell, MTBuilt 1998 · S/N E-3161N523DBN523db LLC · Santa Ana, CABuilt 1999 · S/N EA-643N523SHNesher Wings LLC · Phoenix, AZBuilt 1998 · S/N EA-618N523ZARegistration Pending · Perryton, TXRegistration pendingBuilt 1974 · S/N D-9596N524CBTechnical Film Systems Inc · Camarillo, CABuilt 1991 · S/N TH-1630N524CNSchuele Hans-Peter · Wichita Falls, TXBuilt 1984 · S/N E-2144N524RTN524rt LLC · Greensboro, NCBuilt 1970 · S/N TH-123N525BHWalker Craig · Pleasant View, TNBuilt 1982 · S/N D-10400N525CAWb Aviation LLC · Sugar Grove, ILBuilt 1981 · S/N E-1797N525FSWrb Aircraft Leasing LLC · Wilmington, DEBuilt 2002 · S/N E-3445N525JRPj Flyer LLC · Avondale, AZBuilt 1980 · S/N CE-907N525RRValiair Lc Trustee · Casper, WYBuilt 1997 · S/N E-3069N525TDHigh Sky Bonanza Inc · Wilmington, DEBuilt 1978 · S/N E-1423N525TMVertivue LLC · Allentown, PABuilt 1997 · S/N TH-1832N526BDLoeffelholz John W · Fort Worth, TXBuilt 1984 · S/N TH-1436
Back to AD 87-18-06 R1